SELECT s1.emp_no,(salary - old_salary) AS growth #这里是为了拿到emp_no和薪水涨幅
FROM (SELECT emp_no,salary
FROM salaries
WHERE to_date = '9999-01-01') as s1#这里是为了获取salaries表中的当前薪水情况和emp_no
INNER JOIN (SELECT e.emp_no,s.salary AS old_salary
FROM employees e LEFT JOIN salaries s ON e.emp_no = s.emp_no#这里是为了查到一开始的薪水
AND e.hire_date = s.from_date) as f#这里他内连接了employees表,在这里通过employees表关联salaries查到了开始的薪水
ON s1.emp_no = f.emp_no#关联的条件,即同一个人
ORDER BY growth #最后按照涨幅排序了