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

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