先找出经理的工资多少，然后多表链接就能得出
select d.emp_no,a.emp_no,s.salary,a.salary
from dept_emp d
inner join  salaries s 
on d.emp_no=s.emp_no
inner join (
select m.emp_no,salary,m.dept_no
from dept_manager m 
inner join salaries s 
on m.emp_no=s.emp_no) a 
on d.dept_no=a.dept_no and s.salary>a.salary