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

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