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.

 (20 points) Write a SELECT statement that returns one row for

I want to produce the above output.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!