题解 | #员工其当前的薪水比其manager当前薪水还高#

select b.emp_no
      ,b.manager_no
			 ,b.salary as emp_salary
			 ,s.salary manager_salary from salaries s right join 
(select a.emp_no,s.salary,a.manager_no
	from salaries s 
	right join 
(
select dp.emp_no,dp.dept_no,dr.emp_no manager_no from 
	dept_emp dp left join dept_manager dr
	on dp.dept_no = dr.dept_no
)a
	on a.emp_no = s.emp_no)b
	on s.emp_no = b.manager_no
where b.salary > s.salary