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

select 
	e.emp_no,m.emp_no as manager_no, 
	e.salary as emp_salary,m.salary as manager_salary
from
(		
  select de.emp_no,
  de.dept_no,
  s1.salary
  from 
  dept_emp  de
  join salaries s1 
  on  de.emp_no =s1.emp_no
) e
join 
(
  select  dm.dept_no, dm.emp_no,s2.salary
  from dept_manager dm
  join salaries s2
  on dm.emp_no =s2.emp_no
) m
on e.dept_no=m.dept_no
where e.salary> m.salary