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