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

with A as
(select salary,emp_no from salaries where emp_no  in
(select emp_no from dept_emp where emp_no  not in(
select emp_no from dept_manager))),
B as
(
    select dept_no,A.salary,A.emp_no from dept_emp,A where dept_emp.emp_no=A.emp_no
),
C as 
(select m.dept_no,m.emp_no,s.salary from dept_manager m join salaries s on m.emp_no=s.emp_no)
select B.emp_no as emp_no,C.emp_no as manager_no,  B.salary as emp_salary, C.salary as manager_salary from B,C where B.salary > C.salary and B.dept_no=C.dept_no