Question
(20 points) Write a SELECT statement that returns one row for each customer that has multiple orders. Display these columns: The email_address from the Customers
(20 points) Write a SELECT statement that returns one row for each customer that has multiple orders. Display these columns:
The email_address from the Customers table
A count of the number of orders by each customer
The total order amount for each customer (Hint: First, subtract the discount amount from the price. Then, multiply the difference by the quantity.)
The average order amount for each customer
Return only those rows where the customer has more than 1 order. Sort the result set in descending sequence by the order_total column. Round the values on the average order amount column, so that the values include only two decimal spaces.
I want to produce the above output.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started