Top 3 Users by Purchase Frequency | Dataford Interview Questions

Given a table of user transactions, write a query to identify the top 3 users by purchase frequency per region.

Count each transaction as one purchase. Exclude transactions whose region is NULL. Break frequency ties by ascending user_id.

Output

One row per qualifying user and region
Columns: region, user_id, purchase_frequency, and frequency_rank
Include up to three users per region, ordered by region, frequency_rank, then user_id

user_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	Identifier of the purchasing user
region	VARCHAR(50)	Region associated with the transaction
transaction_date	DATE	Date when the transaction occurred

Your question is Top 3 Users by Purchase Frequency. 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.

Given a table of user transactions, write a query to identify the top 3 users by purchase frequency per region.

Count each transaction as one purchase. Exclude transactions whose region is NULL. Break frequency ties by ascending user_id.

One row per qualifying user and region
Columns: region, user_id, purchase_frequency, and frequency_rank
Include up to three users per region, ordered by region, frequency_rank, then user_id

user_transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	Identifier of the purchasing user
region	VARCHAR(50)	Region associated with the transaction
transaction_date	DATE	Date when the transaction occurred

Your question is Top 3 Users by Purchase Frequency. 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.