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