可以用2次salary表+一张employees，一张salary表用来联合employees查询初始工资，另一张拿来查最终工资顺便判断是否离职
代码如下：

select e.emp_no, s2.salary-s1.salary as growth
from salaries s1 left join employees e on s1.emp_no=e.emp_no left join salaries s2 on s1.emp_no=s2.emp_no
where s1.from_date=e.hire_date and s2.to_date ="9999-01-01"
group by e.emp_no
order by growth