数据库SQL刷题21-25

21、题目描述
查找所有员工自入职以来的薪水涨幅情况，给出员工编号emp_no以及其对应的薪水涨幅growth，并按照growth进行升序
CREATE TABLE employees (
emp_no int(11) NOT NULL,
birth_date date NOT NULL,
first_name varchar(14) NOT NULL,
last_name varchar(16) NOT NULL,
gender char(1) NOT NULL,
hire_date date NOT NULL,
PRIMARY KEY (emp_no));
CREATE TABLE salaries (
emp_no int(11) NOT NULL,
salary int(11) NOT NULL,
from_date date NOT NULL,
to_date date NOT NULL,
PRIMARY KEY (emp_no,from_date));
代码：

SELECT T.emp_no,(T.salary-H.salary) AS growth
FROM 
(SELECT emp_no,salary FROM salaries WHERE to_date='9999-01-01' )AS T
INNER JOIN
(SELECT E.emp_no,S.salary 
FROM employees E LEFT JOIN salaries S ON E.emp_no =