-- Count how many orders each customer has placed.

SELECT customer_id, COUNT(coupon_code) AS orders

FROM orders

GROUP BY customer_id;