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

with t1 as
(select emp_no,max(salary) salary_max from salaries where to_date='9999-01-01' group by emp_no),
t2 as (select s.emp_no,s.salary from salaries s inner join employees e on s.emp_no=e.emp_no where s.from_date=e.hire_date)

select t1.emp_no,t1.salary_max-t2.salary growth from t1 left join t2 on t1.emp_no=t2.emp_no order by growth asc;