with s2 as (
select emp_no ,salary as salary2 from (
select emp_no,salary
from salaries
where to_date='9999-01-01'
) t ),
s1 as (
select e.emp_no, salary as salary1 from 
salaries s
join employees e on e.emp_no=s.emp_no
and hire_date =from_date 
)
select s2.emp_no,salary2-salary1 as growth
from s2 
join s1 on s1.emp_no=s2.emp_no
order by growth;