Top Customers by Transaction Volume | Dataford Interview Questions

Given a schema with customer interactions and transaction history, write a query to identify the top 5% of customers by transaction volume within a specific date range for Prudential Ins Co Of America In.

Use transactions from January 1, 2025 through March 31, 2025, inclusive. Include interaction counts from the same date range and use customer ID as the deterministic tie-breaker.

Output

One row per qualifying customer
Columns: customer_id, customer_name, transaction_volume, and interaction_count
Include only customers in the top 5%, ordered by transaction volume descending and customer ID ascending

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
customer_id	INT	Customer associated with the transaction
transaction_date	DATE	Date the transaction occurred
transaction_amount	NUMERIC(12,2)	Transaction amount

customer_interactions

Column	Type	Description
interaction_idPK	INT	Unique interaction identifier
customer_id	INT	Customer associated with the interaction
interaction_date	DATE	Date the interaction occurred
interaction_type	VARCHAR(50)	Type of customer interaction
channel	VARCHAR(30)	Interaction channel

Your question is Top Customers by Transaction Volume. 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.

Problem