获取员工其当前的薪水比其manager薪水还高的相关信息

#子查询联结两表，通过联结三个表，获取员工，经理，员工工资，外部查询通过联结经理的序号
#获取了经理的薪资水平，然后通过where进行最终的筛选
SELECT qqq.emp_no, manager_no, qqq.salary, s.salary AS manager_salary
FROM (
         SELECT d.emp_no, e.emp_no AS manager_no, s.salary
         FROM dept_emp d
                  INNER JOIN dept_manager e ON d.dept_no = e.dept_no
                  INNER JOIN salaries s ON s.emp_no = d.emp_no
         WHERE d.to_date = '9999-01-01'
     ) qqq
         LEFT JOIN salaries s ON s.emp_no = qqq.manager_no
where qqq.salary >s.salary