#当前工资
with a as
(select emp_no,salary as now_salary
from salaries
where to_date ='9999-01-01'),
#起始工资
b as
(select s.emp_no,salary  as begin_salary
from salaries s
join employees e on s.emp_no = e.emp_no
where from_date = hire_date
)

select a.emp_no,(now_salary-begin_salary) as growth
from a
join b on a.emp_no = b.emp_no
order by growth

二刷 简单