Reference no: EM133218319
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.
Q5 Complete Q5 from textbook page 493. Total quantities per ISBN (orderitems table) for your subquery.
Q6 List 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 Provide your own (original) question and generate a sub-query for the report.