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

with manager_salary as(
    select dm.dept_no as manager_dept, dm.emp_no as manager_no, s.salary as manager_salary from dept_manager dm inner join salaries s on dm.emp_no = s.emp_no),
    
    emp_salary as(
    select de.dept_no as employee_dept, de.emp_no as employee_no, s.salary as emp_salary from dept_emp de inner join salaries s on de.emp_no = s.emp_no)

select es.employee_no as emp_no, ms.manager_no, es.emp_salary, ms.manager_salary from manager_salary ms inner join emp_salary es on ms.manager_dept = es.employee_dept where ms.manager_salary < es.emp_salary