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

with man_sal as (
select dm.emp_no,
dept_no ,
salary as manager_salary
from dept_manager dm
join salaries s on s.emp_no=dm.emp_no
),
emp_sal as (
select de.emp_no,
dept_no ,
salary as emp_salary
from dept_emp de
join salaries s on s.emp_no=de.emp_no
)
select es.emp_no,ms.emp_no as manager_no,emp_salary,	manager_salary
from emp_sal es
join man_sal  ms on  ms.dept_no =es.dept_no 
where emp_salary>manager_salary;