Please use SQL Developer to write and run the queries below. Copy and paste your query code into the submission box. This assignment should be completed by July 19^th.

Write a query that shows the total sales for an order date in 2009. Label the data "Total Sales in 2009".

Write a query that shows largest profit for books in the Computer category.

Write a query that displays each shipstate along with the number of orders shipped to that state. Display the results in descending order by state

Write a query that displays order number and the total paid for each order. Format the amount using dollars and cents. Label the total amount "Order Total."

Write a query to show the retail price of the most expensive book written by Lisa White.