USE SQL Developer

1. Write a query that shows the title(s) of the book most frequently purchased by the customers in the database. Use the quantity column from the orderitems table to find the book most frequently purchased.
2. Write a query that displays the names of the customers who purchased the book with the highest retail price in the database. Capitalize the first and last names.
3. 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. Look at the examples on pages 468 and 469 of the textbook.