Oracle 12c SQL

Hands-on Assignments To perform these assignments, refer to the tables in the JustLee Books database. 1. Determine how many books are in the cooking category. 2. Display the number of books with a retail price of more than $30.00. 3. 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 4. reflected in the total profit calculation. 5. List the retail price of the least expensive book in the Computer category. 6. 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