题解 | #获取有奖金的员工相关信息。#

select a.emp_no,a.first_name,a.last_name,b.btype,c.salary,replace(format((b.btype*c.salary/10),1),',','') as bonus
from employees a,emp_bonus b,salaries c 
where a.emp_no=b.emp_no and a.emp_no=c.emp_no and c.to_date='9999-01-01'
order by emp_no