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

select t1.emp_no, t1.manager as manager_no, t1.emp_salary, t1.manager_salary
from(
    select de.*, 
    s1.salary as emp_salary, 
    dm.emp_no as manager, 
    s2.salary as manager_salary
    from dept_emp de
    left join salaries s1
    on de.emp_no = s1.emp_no
    left join dept_manager dm
    on de.dept_no = dm.dept_no
    left join salaries s2
    on dm.emp_no = s2.emp_no
) t1
where t1.emp_salary - t1.manager_salary > 0