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

select s1.emp_no,(
(	select s2.salary
	from salaries s2
	where s2.emp_no = s1.emp_no and s2.to_date = '9999-01-01') -
	(
		select s3.salary
		from salaries s3
		where s3.emp_no = s1.emp_no and s3.from_date = e1.hire_date
	)
) as growth
from employees e1
left join salaries s1 on e1.emp_no = s1.emp_no
where s1.to_date = '9999-01-01'
order by  growth asc