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

分别查询出两个子表：员工工资表和经理工资表

SELECT
    emp_no,
    manager_no,
    emp_salary,
    manager_salary
FROM (SELECT
    emp_no,
    salary AS emp_salary,
    dept_no AS e_dept_no
FROM dept_emp
JOIN salaries USING(emp_no)) es
JOIN (SELECT
    emp_no AS manager_no,
    salary AS manager_salary,
    dept_no AS m_dept_no
FROM dept_manager
JOIN salaries USING(emp_no)) ms
    ON es.e_dept_no = ms.m_dept_no AND es.emp_salary > ms.manager_salary