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

select eb.emp_no, e.first_name, e.last_name, eb.btype, s.salary, 
        round(s.salary * (case eb.btype 
                            when 1 then 0.1
                            when 2 then 0.2 
                            else 0.3
                            end), 1) bonus
from employees as e 
    join salaries as s on e.emp_no = s.emp_no 
    join emp_bonus as eb on eb.emp_no = s.emp_no and eb.recevied <= s.to_date and eb.recevied >= s.from_date
order by emp_no asc