9.6   SELECT Name
        FROM SALESPERSON
        WHERE Age BETWEEN 50 AND 59

9.7   SELECT Name
        FROM SALESPERSON
        WHERE Age LIKE '5_' 

9.8   SELECT Name
        FROM CUSTOMER
        WHERE City LIKE '%S' 

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

9.10  SELECT COUNT(*)
        FROM ORDER

9.11  SELECT COUNT(DISTINCT CustName)
        FROM ORDER

9.12  SELECT AVG(Age)
        FROM SALESPERSON

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

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

9.19  SELECT Age
        FROM SALESPERSON, ORDER, CUSTOMER
        WHERE SalespersonName=SALESPERSON.Name AND
              CustName=CUSTOMER.Name AND
              City='Memphis'

      Note: 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.