SELECT a.emp_no, (b.salary - a.salary) AS growth FROM( SELECT e.emp_no, e.first_name, e.last_name, e.hire_date,s.salary, s.from_date, s.to_date FROM employees e LEFT JOIN salaries s ON e.emp_no = s.emp_no WHERE e.hire_date = s.from_date ) As a --- 刚开始的薪资 , ( SELECT e.emp_no,...
投递华为等公司10个岗位