Top Taskers Per City Query | Dataford Interview Questions
Top Taskers Per City Query
HardWindow FunctionsRankingAggregations
Problem
Given a massive table of historical Tasker transactions at TaskRabbit, write a query to find the top 3 highest-earning Taskers per city, optimized for execution speed.
Problem
Given a massive table of historical Tasker transactions at TaskRabbit, write a query to find the top 3 highest-earning Taskers per city, optimized for execution speed.
Your answer
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
