复杂子嵌套实例

思路点：在父查询where中查询的条件，就在子查询中继续作为第一个查询的点查询
例如：父查询where InCome
子查询就select InCome

SELECT Name
  FROM employees
    WHERE 
    EmployeeID IN
      (SELECT EmployeeID
           FROM salary
           WHERE InCome > ALL               例如：父查询where InCome
               (SELECT InCome                        子查询就select InCome
                    FROM salary
                        WHERE EmployeeID IN
                          (SELECT EmployeeID
                               FROM employees
                                 WHERE DepartmentID =
                                   (SELECT DepartmentID
                                       FROM departments
                                         WHERE DepartmentName='市场部')
                            )
                    )
            )
  AND 
    DepartmentID=
      (SELECT DepartmentID
           FROM departments
             WHERE DepartmentName='研发部')