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

with t1 as (
    select emp_no, salary,
    lead(salary) over(partition by emp_no order by from_date) as salary2
    from employees join salaries using(emp_no)
    where emp_no in (select distinct emp_no from employees join salaries using(emp_no) where to_date = '9999-01-01')
)
select emp_no, sum(salary2 - salary) as growth from t1 group by emp_no order by growth