题解 | #获取有奖金的员工相关信息。#
获取有奖金的员工相关信息。
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
投递快手等公司6个岗位
查看10道真题和解析