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

SELECT 
  e.emp_no, 
  e.first_name, 
  e.last_name, 
  b.btype, 
  s.salary,
  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 AS 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
AND s.to_date = '9999-01-01'
order by e.emp_no