Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

30-day Rolling Average Window

Medium
SQL & Data ManipulationWindow FunctionsDate Functionsnull handling

Problem

What SQL window function would you use to compute a 30-day rolling average by department, and how would you handle missing dates?

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
Early warningRolling 30-Day AverageMediumGranularRolling Average with SQL WindowsMediumForvis Mazars Group30-Day Moving Average in SQLMedium
0 / ~200 words