提交一种思路
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
先找到每个dept的manager的薪水，再把每个部门manager的薪水和这个部门的员工的薪水关联成一张表，最后从这张表里找到员工的薪水>manager的薪水的记录就OK啦。
select de.emp_no, ms.emp_no as manager_no, ss.salary as emp_salary,ms.salary as manager_salary from dept_emp as de inner join salaries as ss on ss.emp_no=de.emp_no left join (select dm.dept_no, dm.emp_no, ss.salary from dept_manager as dm inner join salaries as ss on dm.emp_no=ss.emp_no) as ms on ms.dept_no=de.dept_no where ss.salary>ms.salary
投递华为等公司9个岗位 >
