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