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