10/21/2000 practice exercises, continued (Q. 4)

Write the questions that are answered by the following queries in
Chapters 5 and 6 (List... or Show... count as questions in this
context).  Comment on problems you might have formulating the questions.

a.  Last query on p.  145 and the two queries on p.  146

List the different publisher(IDs) in order of increasing ID.
What types of books are published, listed by type?  
Which publisher works with each book type (or similar...)? 

b.  Queries on pp.  148-149

List the publishers in the database sorted by the type of book they
publish.
List the types of book published sorted by publisher ID.

c.  Queries on pp.  164-165

Note: There is no good way to ask a question answered by either of these
queries if the aggregate function is count(type), as it is in my edition
of the textbook.  Assuming count(title) or count(title_id):

How many books does each publisher publish?
How many books of each type are published by each publisher?  

d.  Queries on pp.  176-177

Show the average advance paid for each [book] price.
What is the average price for each type of book for which the advance is
greater than $5000?
What is the average price for each type of book?

e.  The two complete queries on p.  183

How many advance payments greater than $10000 were made by each
publisher for each type of book?

Note:  Both queries answer similar questions, but in the first, rows 
are eliminated before grouping (WHERE), while in the second, rows are
eliminated after grouping (HAVING).  Compare this version of the
question with the authors' version on page 185.