SQL CASE for Customer Segments | Dataford Interview Questions

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

Your question is SQL CASE for Customer Segments. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

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.

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

Your question is SQL CASE for Customer Segments. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.