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