题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息
select dee.emp_no,dem.emp_no,sa.salary,a.salary from dept_emp dee join dept_manager dem on dem.dept_no = dee.dept_no join salaries sa on dee.emp_no = sa.emp_no join (select emp_no,salary from salaries where emp_no in (select emp_no from dept_manager)) a on a.emp_no = dem.emp_no where sa.salary > a.salary
四表连接,然后where筛选