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