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

select
    s.emp_no,
    b.emp_no as manager_no,
    s.salary as emp_salary,
    b.salary as manager_salary
from
    dept_emp as de
    inner join salaries as s on de.emp_no = s.emp_no    # 员工薪水表
    inner join(
        select  # 经理薪水表
            dept_no,
            s.emp_no,
            salary
        from
            dept_manager as dm
            inner join salaries as s on dm.emp_no = s.emp_no
    ) as b
    on de.dept_no = b.dept_no # 员工薪水表连接上同部门经理的薪水表
    where s.salary > b.salary # 筛选员工薪水比部门经理高的记录