题解 | 获取有奖金的员工相关信息。
获取有奖金的员工相关信息。
https://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
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
