-- Count orders per customer SELECT customer_id, COUNT(*) AS total_orders, SUM(amount) AS total_spent, AVG(amount) AS avg_order FROM orders GROUP BY customer_id HAVING total_spent > 1000 ORDER BY total_spent DESC;