个人拙见
select
e.emp_no,
(s2.salary - s1.salary) growth
from employees e
join salaries s1
on e.emp_no = s1.emp_no and e.hire_date = s1.from_date
join salaries s2
on s1.emp_no = s2.emp_no and s2.to_date= '9999-01-01'
where s2.salary >= s1.salary
order by growth