Hands-on Assignments 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 verify the results before writing the entire query the 1. List the book title and retail price for all books with a retail price lower than the aver 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. Determine which orders had a higher total amount due than order 1008