no.24

SELECT dept_no, e1.emp_no, salary
FROM dept_emp e1 JOIN salaries s1
ON e1.emp_no=s1.emp_no
WHERE e1.emp_no IN (
    SELECT e.emp_no
    FROM dept_emp e LEFT OUTER JOIN dept_manager m
    ON e.emp_no=m.emp_no
    WHERE m.dept_no IS NULL
);