Q1 How many books are there in the Computer category? Use column alias for a column with the number of books, show category and the number of books in your report.

Q2 Find out how many books each author wrote. Display the authors first and last name and how many books (s)he wrote. Sort by last name, then first name.

Q3 Calculate the total paid for the order 1009. Consider quantity in calculations, some books may be purchased in multiple copies.

Q4 Find the average retail price of books in each of the Children and Business categories, use a single query to show the average for Children and Business books (two records in the results).

CUSTOMERS Customer Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKAUTHOR AUTHOR BOOKS ISBN Authors ISBN AuthorID Lname Title Fname Pubdate PublD Cost Retail Discount PUBLISHER Category PublD Name PROMOTION Contact Phone Gift Minretail Maxretail FIGURE 1-5 JustLee Books's table structures after normalization