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

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