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

需要额外求两张表：

1.员工工资 emp_no, dept_no, emp_salary。其中dept_no用于后面查询本部门领导工资。

2.部门领导工资dept_no，manager_no，manager_salary（领导工资）

最后连接两表的相同部门，筛选符合要求的员工

with manager_sal as (
    select dm.dept_no, 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
), 
employee_sal as (
    select de.emp_no, de.dept_no, s.salary as emp_salary
    from dept_emp de inner join salaries s
    on de.emp_no = s.emp_no
)

select es.emp_no, ms.manager_no, es.emp_salary, ms.manager_salary
from manager_sal ms inner join employee_sal es
on ms.dept_no = es.dept_no
where ms.manager_salary < es.emp_salary