select s.emp_no,a.manager_no,s.salary as emp_salary,a.manager_salary
from salaries s left join dept_emp de on s.emp_no = de.emp_no
left join
(select dm.emp_no as manager_no,dm.dept_no,s.salary manager_salary
from dept_manager dm,salaries s
where dm.emp_no = s.emp_no) a
on de.dept_no = a.dept_no
where de.emp_no != a.manager_no and s.salary > a.manager_salary