Customer segments

Write a customer segment report with AVG.

Customer segment

To find the customer segment you compute the average order value with AVG(amount).

SELECT customer_id, AVG(amount) AS avg_order
FROM sales
GROUP BY customer_id;

This query gives the average order value per customer.

customer_id, AVG(amount) AS avg_order is selected from sales. Rows are grouped by customer_id; aggregate functions are computed per group.

AVG skips NULL values. A high average signals a premium segment.

For example, you can separate customers whose average order is over 500 with HAVING AVG(amount) > 500 and add them to a special campaign list.

Compute the average order value per customer with AVG(amount).

Show example solution

SELECT customer_id, AVG(amount) AS avg_order
FROM sales
GROUP BY customer_id;

Add AVG

SELECT customer_id, ____(amount) AS avg_order
FROM sales
GROUP BY customer_id;

Show answer

SELECT customer_id, AVG(amount) AS avg_order
FROM sales
GROUP BY customer_id;