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
Get step-by-step solutions from verified subject matter experts
