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

-- 经理工资
# select
#     dept_no,
#     d.emp_no as manager_no,
#     s.salary as manager_salary
# from
#     dept_manager d
#     left join salaries s on d.emp_no = s.emp_no

select
    d.emp_no, m.manager_no, s.salary as emp_salary, m.manager_salary
from
    (
        select
            dept_no,
            d.emp_no as manager_no,
            s.salary as manager_salary
        from
            dept_manager d
            left join salaries s on d.emp_no = s.emp_no
    ) m
left join dept_emp d on m.dept_no=d.dept_no and m.manager_no !=d.emp_no
left join salaries s on d.emp_no=s.emp_no
where s.salary>m.manager_salary;