SQL Rolling Average and Ranking | Dataford Interview Questions
SQL Rolling Average and Ranking
MediumWindow FunctionsRankingRunning Totals
Problem
How would you design a SQL query using window functions to compute a rolling 7-day average and rank customers by recent transaction volume for Morgan Stanley?
Problem
How would you design a SQL query using window functions to compute a rolling 7-day average and rank customers by recent transaction volume for Morgan Stanley?
Your answer
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.