9.18  SELECT PercentOfQuota
        FROM SALESPERSON
        WHERE Name IN (SELECT SalespersonName
                         FROM ORDER
                         WHERE CustName IN (SELECT Name
                                              FROM CUSTOMER
                                              WHERE City='Memphis')) 

9.21  SELECT Name, CustName
        FROM SALESPERSON LEFT OUTER JOIN ORDER
                 ON Name=SalespersonName

9.25  INSERT
        INTO CUSTOMER (Name, City, IndustryType)
        VALUES ('Jones Pharmacy', 'Chicago', 'B')

9.26  INSERT
        INTO SALESPERSON (Name, PercentOfQuota)
        VALUES ('Williams', 50)
      Note: The question has an error! It should read "Show a SQL statement
            to insert a new name and quota percent..."   

9.27  INSERT
        INTO HIGH-ACHIEVER (Name, Salary)
          SELECT Name, Salary
                  FROM SALESPERSON
                  WHERE Salary >= 100000 

9.28  DELETE
        FROM CUSTOMER 
        WHERE Name='Abernathy Construction'

9.29  DELETE
        FROM ORDER 
        WHERE Name='Abernathy Construction'

9.30  UPDATE SALESPERSON
        SET Salary=45000 
        WHERE Name='Jones'

9.31  UPDATE SALESPERSON
        SET Salary=Salary * 1.1