Write a select statement that returns one row for each customer that has orders with these columns: the email_address column from the customers table a count of the number of orders the total amount for each order (hint: first, subtract the discount amount from the price. then, multiply by the quantity.) return only those rows where the customer has more than 1 order. sort the result set in descending sequence by the sum of the line item amounts

The statement is as follows:

Explanation:

We had better avoid such correlated subqueries by instead using aggregation with GROUP BY:

SELECT

   c.email_address,

   COUNT(DISTINCT o.order_id) AS num_orders,

   COALESCE(SUM(oi.quantity * (oi.item_price - oi.discount_amount)), 0) AS total_amount

FROM customers c

LEFT JOIN orders o

   ON c.customer_id = o.customer_id

INNER JOIN order_items oi

   ON o.order_id = oi.order_id

GROUP BY

   c.customer_id,

   c.email_address;

explanation:

i don't understand really? can u provide more information

u should make a machine that can make ice cream fresh!