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

select
t1.emp_no,
manager_no,
t1.salary,
salaries.salary as manager_salary

from 
(
select
    salaries.emp_no,
    dept_manager.emp_no as manager_no,
    salaries.salary
from
    salaries
    left join dept_emp on salaries.emp_no = dept_emp.emp_no
    left join dept_manager on dept_emp.dept_no = dept_manager.dept_no
) t1
left join salaries on t1.manager_no=salaries.emp_no
where t1.salary>salaries.salary