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

select
emp_no
,first_name
,last_name
,btype
,salary
,case when e2.btype= 1 then s.salary * 0.1
    when e2.btype= 2 then s.salary * 0.2
    else s.salary*0.3 end
from
employees e1
join emp_bonus e2
using(emp_no)
join salaries s
using(emp_no)
where
s.to_date='9999-01-01'
order by emp_no;