Q1 List the
first name and the last name of each customer who placed more than the average
number of orders. Along with the names, show the total each of the listed
customers paid on all orders he or she placed.
Q2 Use a CORRELATED subquery to show which authors' books have not been ordered.
Q3 List the customers who placed an order for the least expensive book, include the title and price of the book in your output.
Q4 List the name of the publisher(s) that published most books.
titles of books in the same category as books ordered by Giana Tammy. Do not
list the books she already ordered.
Q7** It looks like someone is generating orders with stolen account numbers. The credit card company says they repeat orders for the same amount. JustLee knows that order 1003 is one of the fraudulent ones and needs to find other orders for the same amount so they can check up on them, too. Show orders (calculate total order) that are for the same amount as order 1003.
Q8 Create your own (original) question and write a sub-query for the report.