题解 | 获取所有非manager员工当前的薪水情况

with emp_manager as (
    select d1.emp_no as emp_no,d1.dept_no as dept_no,d2.emp_no as manager_no
    from dept_emp as d1
    inner join dept_manager as d2 on d1.dept_no=d2.dept_no
)

select m.dept_no as dept_no,m.emp_no as emp_no,salary
from emp_manager as m
inner join salaries as s on m.emp_no=s.emp_no
where s.emp_no not in (select distinct manager_no from emp_manager);