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

select
    dept_emp.dept_no,
    salaries.emp_no,
    salaries.salary
from
    salaries
    left join dept_emp on salaries.emp_no = dept_emp.emp_no
where
    salaries.emp_no in (
        select
            e.emp_no
        from
            employees e
        where
            e.emp_no not in (
                select
                    emp_no
                from
                    dept_manager
            )
    )