代码逻辑:先分出两张表——员工、经理;然后进行薪资比较;

select e.emp_no as emp_no, m.emp_no as manage_no,e.salary as emp_salary,m.salary as manager_salary
from 
(
    select demp.emp_no ,demp.dept_no,s1.salary 
    from   dept_emp demp 
    inner join salaries s1 
    on demp.emp_no=s1.emp_no
)e 
inner join (
    select dman.emp_no,dman.dept_no,s2.salary 
    from dept_manager  dman
    inner join salaries s2 
    on dman.emp_no=s2.emp_no
)m
on e.dept_no=m.dept_no 
where e.salary>m.salary