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

with t1 as(select
a.emp_no,
b.emp_no as manager_no
from 
dept_emp a left join dept_manager b
on a.dept_no=b.dept_no and a.emp_no<>b.emp_no) 

select
t2.emp_no,
t2.manager_no,
t2.emp_salary,
t3.manager_salary

from

(select
t1.emp_no,
t1.manager_no,
s.salary as emp_salary
from t1
left join salaries s on t1.emp_no=s.emp_no) t2

left join

(select
t1.emp_no,
t1.manager_no,
s.salary as manager_salary
from t1
left join salaries s on t1.manager_no=s.emp_no) t3

on t2.emp_no=t3.emp_no

where t2.emp_salary>t3.manager_salary