Database SQL

Hands-on Assignments To perform these assignments, refer to the tables in the JustLee Books database. Se 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