-- Average discount per customer across all their orders.

-- (orders placed without a coupon store discount = NULL)

SELECT customer_id, AVG(discount) AS avg_discount

FROM orders

GROUP BY customer_id;