题解 | 获取员工其当前的薪水比其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 de.dept_no = dm.dept_no
INNER JOIN 
    salaries mg ON dm.emp_no = mg.emp_no
WHERE 
    e.salary > mg.salary;