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 no later than July 23^rd.

Write a query that displays the title, ISBN, retail price, and cost of books whose retail price is greater than the average price of all books. Format the retail price with dollars and cents.

Write a query that displays the ISBN, order date, and customer# of the oldest order(s) in the orders table. Format the date with the complete name of the month and a comma after the day of the month, like "January 3, 2011.

Write a query that shows the title and cost of books that are less than the average cost of books in the database.

Write a query that displays the names of the customers who purchased the oldest book in the database. Capitalize the first and last names.

Write a query that displays the first name and last name of each author along with the number of books he or she has written. Capitalize the first and last names.