Please write the SQL code in SQL Developer to complete the tasks below. Then click on Write Submission and copy and paste the code into the submission box. This assignment should be completed no later than August 2nd

Create a view called INVENTORY that contains the ISBN, title, wholesale cost, discount, retail price, profit, and category from the books table. Calculate the profit as retail-cost.

Write a query that lists the ISBN and title of the books in the fitness category from the INVENTORY view.

Write a query that lists the five least expensive books, based on retail price, using the INVENTORY view. Show the title, retail price, and profit.

Create a view called ORDER_TOTALS that contains the customer first name and last name, order number, and order total for each order. Format the order total with dollars and cents.

Write a query that shows the customer name, order number, and total for the largest order in the ORDER_TOTALS view.