select de.emp_no,dm.emp_no manager_no,s1.salary emp_salary,s2.salary manager_salary
from dept_emp de
join dept_manager dm
on de.dept_no = dm.dept_no
join salaries s1 
on de.emp_no = s1.emp_no
join salaries s2 
on dm.emp_no = s2.emp_no
where s1.salary > s2.salary