[Solved] ITSE 2309 Database Programming: Oracle Lab 10 Subqueries and MERGE

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.

1. 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.

2. Determine which books cost less than the average cost of other books in the same category.

3. Determine which orders were shipped to the same state as order 1014.

4. Determine which orders had a higher total amount due than order 1008.

5. List the title of all books in the same category as books previously purchased by customer1007. Dont include books this customer has already purchased.

6. List the shipping city and state for the order that had the longest shipping delay.

7. Determine which customers placed orders for the least expensive book (in terms of regular retail price) carried by JustLee Books.

8. Determine the number of different customers who have placed an order for books written or cowritten by James Austin.

9. Determine which books were published by the publisher of The Wok Way to Cook.

Upload only the SQL Statements to Blackboard.