题解 | #获取有奖金的员工相关信息。#

select
    e.emp_no,
    first_name,
    last_name,
    btype,
    salary,
    round(
        if (
            btype = 1,
            salary * 0.1,
            if (btype = 2, salary * 0.2, salary * 0.3)
        ),
        1
    ) as bonus
from
    employees e,
    emp_bonus eb,
    salaries s
where
    e.emp_no = eb.emp_no
    and e.emp_no = s.emp_no
    and to_date = '9999-01-01'
order by
    e.emp_no