with t as (
    select emp_no
    from employees
    where emp_no not in (
        select emp_no from dept_manager
    )
)
select a.dept_no, t.emp_no, salary
from t 
join dept_emp a on t.emp_no=a.emp_no
join salaries b on t.emp_no=b.emp_no