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

select emp_no,manager_no,emp_salary,manager_salary
from
(select e.emp_no as emp_no,dept_no,salary as emp_salary
from dept_emp as e
inner join salaries as s on e.emp_no=s.emp_no) as e
inner join
(select dept_no,m.emp_no as manager_no,salary as manager_salary
from dept_manager as m
inner join salaries as s on m.emp_no=s.emp_no) as m
on e.dept_no=m.dept_no
where emp_salary>manager_salary;