SELECT 
T2.dept_no,
T1.emp_no,
T4.Salary
FROM
employees T1
LEFT JOIN
dept_emp  T2
ON T1.emp_no = T2.emp_no
LEFT JOIN
salaries  T4
ON T1.emp_no = T4.emp_no
WHERE T1.emp_no NOT IN 
(
    SELECT T3.emp_no FROM dept_manager T3
)
AND T2.dept_no IS NOT NULL
AND T1.emp_no IS NOT NULL
AND T4.Salary IS NOT NULL