Interview Questions
Interview Guides
Experiences
Mock Interviews
Pricing
Explore
Sign in
Interview Guides
Get started
All questions
/
SQL & Data Manipulation
Asked 2mo ago
|
The Johns Hopkins University Applied Physics Laboratory
Rolling 7-Day Average in SQL
Medium
Asked at 1 company
Window Functions
Date Functions
Running Totals
Description
Solution
Companies
Discussion
Problem
Use SQL window functions to calculate a rolling 7-day average of daily patient counts by clinic.
Question
Answer
Description
Solution
Companies
Discussion
Problem
Use SQL window functions to calculate a rolling 7-day average of daily patient counts by clinic.
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
Rolling 7-Day Average in SQL
Medium
Rolling 7-Day Average with Window Functions
Hard
7-Day Rolling Average with SQL
Medium
Next question
Rolling 7-Day Average in SQL | Dataford Interview Questions
