To perform these assignments, refer to the tables in the JustLee Books database.
- Determine how many books are in the Cooking category.
- Display the number of books with a retail price of more than $30.00.
- Display the most recent publication date of all books sold by JustLee Books.
- Determine the total profit generated by sales to customer 1017. Note: Quantity should be reflected in the total profit calculation.
- List the retail price of the least expensive book in the Computer category.
- Determine the average profit generated by orders in the ORDERS table. Note: The total profit by order must be calculated before finding the average profit.
- Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn’t recently placed an order with JustLee Books.
- Determine the average retail price of books by publisher name and category. Include only the categories Children and Computer and the groups with an average retail price greater than $50.
- List the customers living in Georgia or Florida who have recently placed an order totaling more than $80.
- What’s the retail price of the most expensive book written by Lisa White?
Upload only the SQL Statements to Blackboard.
