select C.dept_no,C.emp_no,D.salary
from 
(select B.dept_no,A.emp_no
from employees A
left join dept_emp B
on A.emp_no = B.emp_no) as C
left join salaries D
on C.emp_no = D.emp_no
where C.emp_no not in (select emp_no from dept_manager)