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