Top Customer Segment SQL | Dataford Interview Questions

Write a SQL query to identify the top customer segment by revenue using transaction data, including joins and aggregations as needed at Stone.

Use the provided transaction, customer, and segment data. Return every segment tied for the highest total revenue.

Output

One row per top segment, with segment_id, segment_name, and total_revenue.
Include only segments tied for the highest revenue.
Order by total_revenue descending, then segment_name ascending.

customer_segments

Column	Type	Description
segment_idPK	INT	Unique customer segment identifier
segment_name	VARCHAR(100)	Customer segment name

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(150)	Customer name
segment_id	INT	Customer segment identifier

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
customer_id	INT	Customer associated with the transaction
amount	DECIMAL(12,2)	Transaction revenue amount

Your question is Top Customer Segment SQL. Start with the requirements and the three tables 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.