# 经理的员工编号
with manager_no as (
    select distinct
        emp_no
    from 
        dept_manager
)

select 
    dept_emp.dept_no,
    emp_salaries.emp_no,
    emp_salaries.salary
from (
    select
        s.emp_no,
        s.salary
    from 
        salaries as s
    left join 
        manager_no as m_n
    on 
        s.emp_no = m_n.emp_no
    where 
        m_n.emp_no is null
) as emp_salaries
left join 
    dept_emp
on 
    emp_salaries.emp_no = dept_emp.emp_no