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

SELECT aa.emp_no, aa.first_name, aa.last_name, bb.btype, cc.salary,
CASE WHEN bb.btype = 1 THEN cc.salary*0.1
     WHEN bb.btype = 2 THEN cc.salary*0.2
     ELSE cc.salary*0.3
END bonus
FROM employees aa
left join emp_bonus bb on aa.emp_no=bb.emp_no
left join 	salaries cc on aa.emp_no=cc.emp_no
WHERE  cc.to_date='9999-01-01';