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

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