SELECT emp_no,max(salary)-MIN(salary) growth
FROM salaries
WHERE emp_no IN(SELECT emp_no
FROM salaries
where to_date='9999-01-01')
GROUP BY emp_no
ORDER by salary DESC