select emp_no,max(growth) as growth from (select emp_no,salary,max_salary-salary as growth from (select a.emp_no,a.salary,b.max_salary from salaries as a left join (select emp_no,salary as max_salary from salaries where to_date='9999-01-01') as b on a.emp_no=b.emp_no where max_salary is not null) as...