Using the provided Bookstore database, complete the following queries:

Retrieve the names of all customers who have ordered more than one unique book.

Find the total quantity of books ordered for each customer, ordered by total in descending order.

Write a query to display the books $($title and author$)$ that have not been ordered by any customer.

Using a subquery, find the books that have a price greater than the average price of all books.

Calculate the total sales $($quantity $*$ price$)$ for each order placed in the database.

Bonus Questions $($this is optional but worth extra credit$)$

Find the total revenue generated by each book $($title$)-$ worth an extra $10$ points

Hints:

Total Revenue $=$ quantity $*$ price

Use an aggregated function

Find the author who has generated the most total revenue $-$ worth and extra $15$ points

Hints:

You will need to combine aggregate functions and subqueries to find this author