SQL Rolling Average and Ranking | Dataford Interview Questions
SQL Rolling Average and Ranking
HardWindow FunctionsRankingRunning Totals
Problem
Write a SQL query using window functions to calculate each user's 7-day rolling average of transactions and rank users within each region by that average.
Problem
Write a SQL query using window functions to calculate each user's 7-day rolling average of transactions and rank users within each region by that average.
Your answer
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
