[SOLVED] Create reports containing the following details from the database:
Im studying and need help with a MySQL question to help me learn.
Create reports containing the following details from the database:
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 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.
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 What orders were shipped in the least amount of time in days? Show the dates ordered and shipped, without duplicate rows.
Q8 Create your own (original) question and write a sub-query for the report.
Attach and submit your completed assignments in RTF, TXT or SQL format. Please do not include any results from your queries.
ONLY submit the SQL scripts using the following naming convention: HW#_Q#_YourInitials.
For example:
HW6_Q1_DV