Q1 List customers from New Jersey and Florida who placed orders totaling over $30.Aggregate PER order, PER customer.

Q2 Determine the average of ALL orders. Find the total per each order before calculating the average for all orders. Hint: Use nesting.

Q3 Show the most expensive book a customer from Georgia bought. Assign a clear header to this column.

Q4 How much is the least expensive book written by Smith? Combine the author's first and last name in one column in the report/

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