Lab assignment 6
To perform these activities, refer to the tables in Appendix A.
1.Determine which books have a retail price that is less than the average retail price of all books sold by Just Lee Books.
2.Determine which books cost less than 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.Determine which author or authors wrote the book(s) most frequently purchased by customers in Just Lee books.
6.List the title of all books in the same category as books previously purchased by customer 1007. Do not include books already purchased by this customer.
7.List the city and state for the customer(s) who experienced the longest shipping delay.
8.Determine which customers placed orders for the least expensive book (in terms of retail price) carried by Just Lee Books.
9.Determine how many different customers have placed an order for books written or co-written by James Austin.Determine which books were published by the publisher of The wok way to cook
GooD luck in your exams
You marks for assignment 2 will be released soon. Stay Tuned.
