select
d.emp_no,ds.emp_no manager_no,s1.salary emp_salary,ds.salary manager_salary
from
dept_emp d
join
salaries s1
on
d.emp_no=s1.emp_no
join
(select de.dept_no,de.emp_no,s2.salary from dept_manager de join salaries s2 on de.emp_no=s2.emp_no) ds
on
d.dept_no=ds.dept_no
where
s1.salary>ds.salary;
1.内连接子查询出manager的部门编号，员工编号，薪资
2.查询部门员工的编号和薪资
3.where过滤出部门员工大于子查询的薪资的员工信息