题解 | #查找在职员工自入职以来的薪水涨幅情况#

select s1.emp_no,(s2.salary-s1.salary) as growth
from
(select salaries.emp_no,salaries.salary from salaries
where salaries.to_date='9999-01-01')as s2
inner join (select s.emp_no,s.salary from salaries as s
inner join employees as e
on e.hire_date=s.from_date and e.emp_no=s.emp_no)as s1
on s2.emp_no=s1.emp_no
ORDER BY growth;