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

# 分别计算员工薪水表，manager薪水表
select 
    t0.emp_no
    ,manager_no
    ,emp_salary
    ,manager_salary
from (
    select 
    e.emp_no
    ,dept_no
    ,salary as emp_salary
from dept_emp e
left join salaries s
on e.emp_no = s.emp_no
) t0 
left join(
    select
        m.emp_no as manager_no
        ,dept_no
        ,salary as manager_salary
    from dept_manager m
    left join salaries s
    on m.emp_no = s.emp_no
) t1
on t0.dept_no = t1.dept_no
where emp_salary>manager_salary;