Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling Average by Department

Medium
SQL & Data ManipulationWindow FunctionsDate FunctionsRunning TotalsAsked 1 times

Problem

Write a SQL query to calculate the rolling average of patient satisfaction scores over a 30-day period for each hospital department.

You are practicing as a guest. Sign up free to get your answer graded with AI feedback. Your draft stays right here.

Sign up freeI have an account
Sign up to unlock solutions
Press ganey Data Scientist Interview QuestionsPress ganey Interview Questions
Next questions
TruvetaRolling 7-Day Average in SQLMediumOptum TechnologySQL Rolling Average by HospitalMediumMedpaceRolling 7-Day Average with Window FunctionsHard
0 / ~200 words