9.9   SELECT SalespersonName, Salary
        FROM SALESPERSON, ORDER
        WHERE SalespersonName=Name AND
              CustName <> 'Abernathy Construction'
        ORDER BY Salary ASC 

9.14  SELECT SalespersonName, COUNT(*)
        FROM ORDER
        GROUP BY SalespersonName 

9.17  SELECT Name, PercentOfQuota
        FROM SALESPERSON, ORDER
        WHERE SalespersonName=Name AND
              CustName = 'Abernathy Construction'
        ORDER BY PercentOfQuota DESC 

9.19  SELECT S.PercentOfQuota
        FROM SALESPERSON AS S, ORDER AS O, CUSTOMER AS C
        WHERE O.SalespersonName=S.Name AND
              O.CustName=C.Name AND
              C.City='Memphis'

      Note: Renaming (i.e. qualification) is necessary in the above 
      example to resolve the possible ambiguity with the Name column 
      that occurs in both the CUSTOMER and SALESPERSON tables.