SELECT

customers.email$\_$address,

COUNT$($orders$.$order$\_$id$)$ AS order$\_$count,

SUM$(($order$\_$items.item$\_$price $-$ order$\_$items.discount$\_$amount$)*$ order$\_$items.quantity$)$ AS order$\_$total

FROM customers

JOIN orders on customers.customer$\_$id $=$ orders.customer$\_$id

JOIN order$\_$items ON orders.order$\_$id $=$ order$\_$items.order$\_$id

GROUP BY customers.email$\_$address

HAVING COUNT$($order$\_$items.order$\_$id$)>1$

ORDER BY order$\_$total DESC;