题解 | #获取有奖金的员工相关信息。#
获取有奖金的员工相关信息。
https://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
为什么不能用left join? select s.emp_no , e.first_name , e.last_name , es.btype, s.salary , ROUND(case when es.btype= 1 then s.salary *0.1 when es.btype= 2 then s.salary *0.2 when es.btype= 3 then s.salary *0.3 end ,1) as bonus from salaries as s join emp_bonus as es on s.emp_no= es.emp_no join employees as e on s.emp_no =e.emp_no where to_date = '9999-01-01' order by s.emp_no ;
查看4道真题和解析