buhuixie

SELECT 
    dept_emp.emp_no AS emp_no,
    dept_manager.emp_no AS manager_no,
    emp_salaries.salary AS emp_salary,
    mgr_salaries.salary AS manager_salary
FROM 
    dept_emp
JOIN 
    dept_manager ON dept_emp.dept_no = dept_manager.dept_no
JOIN 
    salaries AS emp_salaries ON dept_emp.emp_no = emp_salaries.emp_no
JOIN 
    salaries AS mgr_salaries ON dept_manager.emp_no = mgr_salaries.emp_no
WHERE 
    emp_salaries.salary > mgr_salaries.salary;