1 List the first name and the last name of each customer who placed more than the average number of orders. Along with the names, show the total each of the listed customers paid on all orders he or she placed.

2 Use a CORRELATED subquery to show which authors' books have not been ordered.

3 It looks like someone is generating orders with stolen account numbers. The credit card company says they repeat orders for the same amount. JustLee knows that order 1003 is one of the fraudulent ones and needs to find other orders for the same amount so they can check up on them, too. Show orders (calculate total order) that are for the same amount as order 1003.

4 List the name of the publisher(s) that published most books.\

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