with
tb1 as(
    select employees.emp_no, salary from employees
    join salaries on employees.hire_date = salaries.from_date
),
tb2 as(
    select emp_no, salary from salaries
    where to_date = '9999-01-01'
)
select emp_no, tb2.salary - tb1.salary as growth from tb1
join tb2 using(emp_no)
order by growth