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

select
a.emp_no
,b.salary - a.salary growth
from
(
    select
    emp_no
    ,salary
    from salaries
    where from_date in (
                                        select min(from_date)
                                        from salaries
                                        group by emp_no
                                    )
) a
inner join 
(
    select
    emp_no
    ,salary
    from salaries
    where to_date = '9999-01-01'
) b
on a.emp_no = b.emp_no
order by growth