select  
 a.emp_no
,b.emp_no  manager_no
,c.salary  emp_salary
,d.salary  manager_salary
from  dept_emp  a 
left join  dept_manager  b   
       on  a.dept_no = b.dept_no
left join  salaries c 
       on  a.emp_no = c.emp_no
left join  salaries d 
       on  b.emp_no = d.emp_no
where  a.emp_no != b.emp_no 
  and  c.salary > d.salary