with t as (
    select a.emp_no, b.emp_no as manager_no,
    c.salary as emp_salary, c2.salary as manager_salary
    from dept_emp a join dept_manager b on a.dept_no=b.dept_no
    join salaries c on a.emp_no=c.emp_no
    join salaries c2 on b.emp_no=c2.emp_no
)
select emp_no, manager_no, emp_salary, manager_salary
from t
where emp_no<>manager_no and emp_salary>manager_salary