Interview Questions
Interview Guides
Experiences
Mock Interviews
Pricing
Explore
Sign in
Interview Guides
Get started
SQL Rolling Average by City | Dataford Interview Questions
All questions
/
SQL & Data Manipulation
SQL Rolling Average by City
Medium
Asked at 1 company
Window Functions
sql
Running Totals
Description
Solution
Companies
Discussion
Problem
Write a SQL query using window functions to compute a 7-day rolling average of orders by city.
Question
Answer
Description
Solution
Companies
Discussion
Problem
Write a SQL query using window functions to compute a 7-day rolling average of orders by city.
Your answer
Edit
Preview
Try one AI text evaluation on us
Get structured feedback, scored against a 4-axis rubric. Premium unlocks unlimited.
0 words
target ~200
Try a free preview
Stuck? Get a hint
Past attempts
Up next
SQL Rolling Average With Window Functions
Medium
Rolling Average with Window Functions
Medium
SQL Rolling Average and Ranking
Hard
Next question
