力扣做过鸭

与对应经理的薪水表，连接 筛选

说起来容易做起来难，调试半天

select c.emp_no as manager_no,c.dept_no,c.salary from (select a.emp_no,a.dept_no,b.salary

from dept_emp a join salaries b on a.emp_no=b.emp_no) c
where manager_no in (select emp_no from dept_manager)
#where后面的manager_no会出错，改成c.emp_no就好了。。。WHY

select c.emp_no,manager_no,c.salary,e.salary
from
(select a.emp_no,a.dept_no,b.salary
from dept_emp a join salaries b on a.emp_no=b.emp_no) c #人员，部门，薪水
join
(select d.emp_no as manager_no,d.dept_no,d.salary from (select a.emp_no,a.dept_no,b.salary
from dept_emp a join salaries b on a.emp_no=b.emp_no) d
where d.emp_no in (select emp_no from dept_manager))e#经理，部门，薪水
on c.dept_no=e.dept_no
where c.salary>e.salary