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

关联三张表，并用子查询排除作为经理的员工