题解 | #创建一个actor_name表#
获取有奖金的员工相关信息。
http://www.nowcoder.com/practice/5cdbf1dcbe8d4c689020b6b2743820bf
select
e.emp_no,e.first_name,e.last_name,b.btype,s.salary,s.salaryb.btype0.1 as bonus
from
employees e,emp_bonus b,salaries s
where
s.to_date='9999-01-01'
and e.emp_no=b.emp_no
and b.emp_no=s.emp_no;
