1 a. AUTHORS[FirstName, LastName]
  b. PUBLISHERS[PubName]
  c. (PUBLISHERS WHERE City='Chicago')[PubName]
  d. (TITLES WHERE PubName='Prentice Hall' and Type='Business')[Title, Price] 
  e. STORES[StoreName] - SALES[StoreName]
  f. (TITLES JOIN (TITLE.TitleID=SALES.TitleID) 
            (SALES WHERE StoreName='Borders'))[Title]

2 a. SELECT LastName, FirstName 
       FROM AUTHORS 
       WHERE State='Illinois'
  b. SELECT TitleID, Title 
       FROM TITLES
  c. SELECT TitleID, Title
       FROM TITLES
       WHERE PubDate > '12/31/2000'
  d. SELECT TitleID, Title
       FROM TITLES
       WHERE PubName='Addison-Wesley' AND Type='BioChemistry'
  e. SELECT COUNT(*)
       FROM STORES
  f. SELECT TitleID, Title
       FROM TITLES
       WHERE Title LIKE '%SQL%'