题解 | #获取有奖金的员工相关信息。#
获取有奖金的员工相关信息。
https://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
select em.emp_no, first_name, last_name, btype, salary, case btype when 1 then (salary * 0.1) when 2 then (salary * 0.2) else (salary * 0.3) end as bonus from salaries s inner join emp_bonus e on s.emp_no = e.emp_no inner join employees em on s.emp_no = em.emp_no where to_date='9999-01-01' order by em.emp_no
，我前两天刚拿了一个11k，笔试完第2天就打电话了，非科班。坏消息是c++岗开这么低真是刷新认知了