select emp_no, s_1-s_0 as growth from (select s1.emp_no, salary as s_1 from salaries as s1 where to_date = '9999-01-01') as table0left join( select s2.emp_no, salary as s_0 from salaries as s2 where from_date in (select hire_date from employees) ) as table1using(emp_no)order by growth;