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

select
    employees.emp_no,
    employees.first_name,
    employees.last_name,
    emp_bonus.btype,
    salaries.salary,
    round(
        salaries.salary * (
            case
                emp_bonus.btype
                when 1 then 0.1
                when 2 then 0.2
                else 0.3
            end
        ),
        1
    ) as bonus
from
    employees
    right join emp_bonus on employees.emp_no = emp_bonus.emp_no
    inner join salaries on employees.emp_no = salaries.emp_no
    and salaries.to_date = '9999-01-01'
order by
    employees.emp_no