题解 |

# 获取一个表包含部门经理员工号和工资字段
select dept_no, dm.emp_no,salary
from dept_manager dm
join salaries s
on dm.emp_no=s.emp_no
# 获取员工其当前的薪水比其manager当前薪水还高的相关信息
select de.emp_no, k1.emp_no manager_no, s.salary emp_salary, k1.salary manager_salary
from dept_emp de
join salaries s
on de.emp_no=s.emp_no
join (
    select dept_no, dm.emp_no,salary
    from dept_manager dm
    join salaries s
    on dm.emp_no=s.emp_no
) k1
on k1.dept_no=de.dept_no and s.salary>k1.salary