select
a.emp_no
,b.emp_no as mangaer_no
,a.salary as emp_salary
,b.salary as manager_salary
from (
select
de.emp_no
,de.dept_no
,s1.salary
from dept_emp de
join salaries s1
on de.emp_no = s1.emp_no
) a
join (
select
dm.emp_no
,dm.dept_no
,s2.salary
from dept_manager dm
left join salaries s2
on dm.emp_no = s2.emp_no
) b
on a.dept_no = b.dept_no
where a.emp_no <> b.emp_no
and a.salary > b.salary