Description
To perform these assignments, refer to the tables in the JustLee Books database. Use a subquery to accomplish each task. Make sure you execute the query you plan to use as the subquery to verify the results before writing the entire query.
- List the book title and retail price for all books with a retail price lower than the average retail price of all books sold by JustLee Books.
- Determine which books cost less than the average cost of other books in the same category.
- Determine which orders were shipped to the same state as order 1014.
- Determine which orders had a higher total amount due than order 1008.
- List the title of all books in the same category as books previously purchased by customer1007. Don’t include books this customer has already purchased.
- List the shipping city and state for the order that had the longest shipping delay.
- Determine which customers placed orders for the least expensive book (in terms of regular retail price) carried by JustLee Books.
- Determine the number of different customers who have placed an order for books written or cowritten by James Austin.
- Determine which books were published by the publisher of The Wok Way to Cook.
Upload only the SQL Statements to Blackboard.
