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 March 5th.

Write a query that shows the total number of orders shipped in 2009. Label the data "Orders Shipped in 2009".

Write a query that shows the latest publication date of 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 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.