with
t1 as(
    select
        dept_emp.dept_no as dept_no,
        dept_emp.emp_no as emp_no
    from
        dept_emp left join dept_manager using(emp_no)
    where
        dept_manager.emp_no is null
),
t2 as(
    select
        dept_no,
        emp_no,
        salary
    from
        t1 left join salaries using(emp_no)
)


select * from t2