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

思路是先分别建立员工工资表和经理工资表，再连表查询

select e.emp_no,m.manager_no,e.emp_salary,m.manager_salary
from (
        select dm.dept_no,dm.emp_no as manager_no,s.salary as manager_salary
        from dept_manager dm join salaries s
            on dm.emp_no=s.emp_no
    )m inner join
    (
        select de.dept_no,de.emp_no ,s.salary as emp_salary
        from dept_emp de join salaries s
            on de.emp_no=s.emp_no
    )e
    on m.dept_no=e.dept_no
where e.emp_salary>m.manager_salary;