SQL25 获取员工其当前的薪水比其manager当前薪水还高的相关信息(https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef?tpId=82&&tqId=29777&rp=1&ru=/ta/sql&qru=/ta/sql/question-ranking)

with t1 as (select s.emp_no emp_no, s.salary emp_salary, d.dept_no dept_no
from salaries s, dept_emp d
where s.emp_no=d.emp_no),

t2 as (select s.emp_no manager_no, d.dept_no dept_no, s.salary manager_salary
from salaries s, dept_emp d, dept_manager m
where s.emp_no=d.emp_no and s.emp_no=m.emp_no)

select distinct emp_no, manager_no, emp_salary, manager_salary
from t1, t2
where t1.dept_no = t2.dept_no and emp_salary>manager_salary