select a.emp_no,a.salary-b.salary as growth
from (select emp_no,salary from salaries where to_date='9999-01-01' ) a
inner join (select s.emp_no ,s.salary from salaries s
inner join employees e
ON s.emp_no=e.emp_no
where e.hire_date=s.from_date)
b
on a.emp_no=b.emp_no order by growth