select
t8.emp_no,t4.manager_no,t8.emp_salary,t4.manager_salary
from 
(select
t1.dept_no,
t3.emp_no manager_no,
t2.salary manager_salary
from dept_emp t1
left join salaries t2
on t1.emp_no=t2.emp_no
left join dept_manager t3
on t1.dept_no=t3.dept_no
where t1.emp_no=t3.emp_no)t4
,
(select
t5.dept_no,
t5.emp_no,
t6.salary emp_salary
from dept_emp t5
left join salaries t6
on t5.emp_no=t6.emp_no
left join dept_manager t7
on t5.dept_no=t7.dept_no
where t5.emp_no<>t7.emp_no)t8
where t4.dept_no=t8.dept_no
and t8.emp_salary>t4.manager_salary