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.
data mining
Description
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.
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 Create your own (original) question and write
a sub-query for the report.
