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

select
g.emp_no,
(g.last_salary-f.orgin_salary) growth
from (   select 
            a.emp_no,
            a.salary orgin_salary
        from salaries a
        left join employees b
        on a.emp_no=b.emp_no
        where a.from_date=b.hire_date) f
right join (select t1.emp_no,t1.salary last_salary
            from salaries t1
            where t1.to_date='9999-01-01') g
on f.emp_no=g.emp_no
order by 2