题解 | #获取有奖金的员工相关信息。#
获取有奖金的员工相关信息。
https://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
select
e.emp_no,
e.first_name,
e.last_name,
eb.btype,
s.salary,
case when eb.btype = 1 then s.salary*0.1
when eb.btype = 2 then s.salary*0.2
else s.salary*0.3
end
from employees e
join emp_bonus eb on e.emp_no = eb.emp_no
join salaries s on s.emp_no = e.emp_no
where to_date='9999-01-01'
查看7道真题和解析
投递水滴等公司10个岗位 >