获取员工其当前的薪水比其manager当前薪水还高

select
    emp.emp_no,
    manage.emp_no,
    emp.salary,
    manage.salary
from
    (
        select
            dept_no,
            salary,
            emp_no
        from
            (
                select
                    *
                from
                    dept_emp
                where
                    emp_no not in (
                        select
                            emp_no
                        from
                            dept_manager
                    )
            ) es
            join salaries ss using (emp_no)
    ) emp
    join (
        select
            dept_no,
            salary,
            emp_no
        from
            salaries s
            join dept_manager dm using (emp_no)
    ) manage where emp.dept_no=manage.dept_no and emp.salary>manage.salary