题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

SELECT
    e.emp_no AS emp_no,
    dm.emp_no AS manager_no,
    e.salary AS emp_salary,
    mg.salary AS manager_salary
FROM
    salaries e
    INNER JOIN dept_emp de on e.emp_no=de.emp_no
    INNER JOIN dept_manager dm on dm.dept_no=de.dept_no
    INNER JOIN salaries mg on mg.emp_no=dm.emp_no
WHERE
    e.salary > mg.salary;