题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

select emp_no, manager_no, emp_salary, manager_salary
from
(select dept_no, salaries.emp_no, salary as emp_salary
from dept_emp join salaries on dept_emp.emp_no=salaries.emp_no 
where salaries.emp_no not in (select emp_no
from dept_manager)) as a
join
(select dept_no, salaries.emp_no as manager_no, salary as manager_salary
from dept_emp join salaries on dept_emp.emp_no=salaries.emp_no 
where salaries.emp_no in (select emp_no
from dept_manager)) as b
 on a.dept_no=b.dept_no
where emp_salary > manager_salary