题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
SELECT s_current.emp_no,
(s_current.salary - s_initial.salary) AS growth
FROM salaries s_initial
JOIN salaries s_current ON s_initial.emp_no = s_current.emp_no
JOIN employees e ON e.emp_no = s_current.emp_no
WHERE s_initial.from_date = e.hire_date
AND s_current.to_date = '9999-01-01'
ORDER BY growth ASC;
