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

select
    t4.emp_no,
    (t4.salary - t3.salary) as growth
from
    (
        select
            t1.emp_no,
            t2.salary
        from
            employees as t1
            join salaries as t2
        where
            t1.hire_date = t2.from_date
    ) as t3
    join (
        select
            emp_no,
            salary
        from
            salaries
        where
            to_date = '9999-01-01'
    ) as t4 on t3.emp_no = t4.emp_no
order by growth asc;