题解 | 用3次表连接即可
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select de.emp_no,dm.emp_no manager_no, s1.salary emp_salary, s2.salary manager_salary from dept_emp de inner join dept_manager dm on de.dept_no=dm.dept_no inner join salaries s1 on de.emp_no=s1.emp_no left join salaries s2 on dm.emp_no=s2.emp_no where de.emp_no !=dm.emp_no and s1.salary>s2.salary
用3次表连接即可