select
dept_no
,s.emp_no
,salary
from salaries s
join dept_emp d_e
on s.emp_no = d_e.emp_no
where s.emp_no not in (
select emp_no
from dept_manager
)