题解 | #员工其薪水比其manager薪水还高的相关信息#

select b.emp_no, a.emp_no, b.salary, a.salary
from
(select dept_manager.emp_no, salaries.salary, dept_manager.dept_no
from dept_manager join salaries on dept_manager.emp_no = salaries.emp_no) a
inner join
(select dept_emp.emp_no, salaries.salary, dept_emp.dept_no
from dept_emp join salaries on dept_emp.emp_no = salaries.emp_no
) b on a.dept_no = b.dept_no

where b.emp_no != a.emp_no and b.salary > a.salary