题解 | #获取所有非manager员工当前的薪水情况#

32ms 

with
    t1 as (
        select
            *
        from
            employees
        where
            emp_no not in (
                select
                    emp_no
                from
                    dept_manager
            )
    )
select
    t2.dept_no,
    t1.emp_no,
    t3.salary
from
    t1
    join dept_emp as t2 on t2.emp_no = t1.emp_no
    join salaries as t3 on t1.emp_no = t3.emp_no