题解 | #获取有奖金的员工相关信息。#
获取有奖金的员工相关信息。
https://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
select distinct emp_no,
first_name,
last_name,
btype,
salary,
CASE WHEN btype = 1 THEN salary * 0.1
WHEN btype = 2 THEN salary * 0.2
ELSE salary * 0.3
END bonus
from employees join emp_bonus using(emp_no) left join salaries using(emp_no)
where to_date="9999-01-01"
order by emp_no
OPPO公司福利 1101人发布