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

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