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

select s.emp_no,a.emp_no as manager_no,s.salary as emp_salary,a.salary as manager_salary FROM salaries s
left join dept_emp de ON s.emp_no=de.emp_no
left join (select d1.dept_no,d1.emp_no,s1.salary as salary from dept_manager d1
inner join salaries s1 on d1.emp_no=s1.emp_no ) a
on de.dept_no=a.dept_no
where s.salary > a.salary