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

with t_hire as (
    select a.emp_no, salary
    from employees a join salaries b on a.emp_no=b.emp_no
    where from_date=hire_date
), t_current as (
    select a.emp_no, salary
    from employees a join salaries b on a.emp_no=b.emp_no
    where to_date='9999-01-01'
)
select t1.emp_no, t2.salary-t1.salary as growth
from t_hire t1 join t_current t2 on t1.emp_no=t2.emp_no
order by growth