select t1.emp_no,end_salary-initial_salary as grouwth from (select ss.emp_no as emp_no,ss.salary as end_salary from salaries ss WHERE ss.to_date='9999-01-01') t1 join (select e.emp_no as emp_no,s.salary as initial_salary FROM employees e join salaries s on e.emp_no=s.emp_no where e.hire_date=s.from_...