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

with start_salary_t as(
    select 
        emp_no ,
        salary
    from employees e join salaries s using(emp_no)
    where hire_date =from_date 
),
end_salary_t as(
    select 
        emp_no ,
        salary
    from salaries
    where to_date='9999-01-01'
)
select 
    emp_no ,
    e.salary-s.salary as growth
from end_salary_t e
    left join start_salary_t s using(emp_no)
order by growth;