题解 | #查找所有员工的last_name和first_name以及对应部门编号dept_no#

只需要第二张表就行啊

select
tb1.emp_no
,tb2.salary - tb1.salary growth
from
(select emp_no,min(salary) salary
from salaries
where emp_no in(select emp_no from salaries where to_date = '9999_01-01')
group by emp_no) as tb1
inner join
(select emp_no,max(salary) salary
from salaries
where emp_no in(select emp_no from salaries where to_date = '9999_01-01')
group by emp_no) as tb2
on tb1.emp_no = tb2.emp_no