select owcs.emp_no,owcs.growth from (select muqian.emp_no,(muqian.salary - douyou.salary) as growth from (select s.emp_no,s.salary from salaries s where s.to_date = '9999-01-01') as muqian inner join (select s.emp_no,s.salary from employees e inner join salaries s on e.hire_date = s.from_date) as douyou on muqian.emp_no = douyou.emp_no) as owcs order by owcs.growth
215最终形式应该像这样