select a.emp_no,b.salary - a.salary growth
from
(select s.emp_no,s.salary
from salaries s join employees e
on e.hire_date = s.from_date) as a
join
(select s.emp_no,s.salary from salaries s
where to_date = '9999-01-01') as b
on a.emp_no = b.emp_no
order by growth

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

思路：

1、识别入职工资：基于入职时间

2、识别离职工资：基于'9999-01-01'

3、表连接，select相减

易错点：

1、入职工资左连接，既有些非入职时间的行工资，也留下了

2、相减，离职-入职

3、字段名写错