题解 | #获取有奖金的员工相关信息。#
获取有奖金的员工相关信息。
http://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
-- 奖金 emp_bonus select s.emp_no, ey.first_name, ey.last_name, e.btype, s.salary, case btype when 1 then s.salary*0.1 when 2 then s.salary*0.2 else s.salary*0.3 end bonus from salaries s join emp_bonus e on s.emp_no = e.emp_no join employees ey on ey.emp_no =s.emp_no where to_date='9999-01-01'