SQL CASE for Customer Segments

EasySQL · PostgreSQL

How would you use a CASE statement to create customer segments?

Using the customers table, assign each customer a segment based on annual_spend. Treat missing spending values as Unclassified.

Output

One row per customer with customer_id, customer_name, and customer_segment
Include all customers and order by customer_id ascending

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer full name
annual_spend	NUMERIC(10,2)	Customer spending during the year

Tablescustomers

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.