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