1 Complete Q5 from textbook page 493. Total quantities per ISBN (orderitems table) for your subquery.

2 List titles of books in the same category as books ordered by Giana Tammy. Do not list the books she already ordered.

3 What orders were shipped in the least amount of time in days? Show the dates ordered and shipped, without duplicate rows.

4 Create your own (original) question and write a subquery for 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