select dp.dept_no, es.emp_no,s.salary
from employees  es
join  dept_emp  dp  using(emp_no)
join  salaries  s   using(emp_no)
where  emp_no not in (select emp_no from dept_manager)