题解 | 获取有奖金的员工相关信息。
获取有奖金的员工相关信息。
https://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
select ep.emp_no, ep.first_name, ep.last_name, eb.btype, s.salary, (salary * btype * 0.1) bonus from employees ep join emp_bonus eb on ep.emp_no = eb.emp_no join salaries s on eb.emp_no = s.emp_no where s.to_date = '9999-01-01' order by ep.emp_no asc