select dept_emp.emp_no, dept_manager.emp_no as manager_no, salaries.salary as emp_salary, 
    salaries2.salary as manager_salary
from dept_emp
left join dept_manager using(dept_no)
join salaries on dept_emp.emp_no = salaries.emp_no
join salaries as salaries2 on dept_manager.emp_no = salaries2.emp_no
where dept_emp.emp_no != dept_manager.emp_no and salaries.salary > salaries2.salary