题解 | 获取有奖金的员工相关信息。
select b.emp_no, e.first_name, e.last_name, b.btype, s.salary, round((case when b.btype=1 then s.salary*0.1 when b.btype=2 then s.salary*0.2 else s.salary*0.3 end),1) bonus from employees e join emp_bonus b on e.emp_no=b.emp_no join salaries s on b.emp_no=s.emp_no where s.to_date='9999-01-01' order by b.emp_no asc