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

SELECT N.e_now,(N.s_now-H.s_hire) growth
FROM
	(SELECT e.emp_no,s.salary s_hire
    FROM employees e INNER JOIN salaries s ON e.emp_no=s.emp_no
    WHERE s.from_date=e.hire_date) H ,
    
    (SELECT emp_no e_now, salary s_now FROM salaries
    WHERE to_date="9999-01-01") N
    
WHERE N.e_now=H.emp_no
ORDER BY growth;