Top 3 Items Per Region Query | Dataford Interview Questions
Top 3 Items Per Region Query
HardWindow FunctionsJoinsAggregations
Problem
Given a massive table of user transactions, write a query to find the top 3 most purchased items per region over the last 30 days, optimizing for a distributed database.
Problem
Given a massive table of user transactions, write a query to find the top 3 most purchased items per region over the last 30 days, optimizing for a distributed database.
Your answer
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
