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

with
    emp_salary as (
        select
            a.emp_no,
            dept_no,
            salary emp_salary
        from
            dept_emp a
            join salaries b using (emp_no)
        where
            a.emp_no not in(
                select
                    emp_no
                from
                    dept_manager
            )
    ),
manager_salary as (
    select
        a.emp_no manager_no,
        dept_no,
        salary manager_salary
    from
        dept_manager a
        join salaries b using (emp_no)
)
select
    emp_no,
    manager_no,
    emp_salary,
    manager_salary
from
    emp_salary a
    left join manager_salary b using (dept_no)
where
    emp_salary > manager_salary