Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

7-Day Rolling Average Comparison

Medium
MediumSQL & Data ManipulationWindow FunctionsLag/LeadRunning TotalsAsked 1 times

Problem

How would you use SQL window functions to compute a 7-day rolling average and compare it to the prior period?

Practicing as: Data Scientist interview at Fanning Personnel

Hi, I'll play your Fanning Personnel interviewer for the Data Scientist role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.

Take this as a live interview session →

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
Fanning Personnel Interview QuestionsFanning Personnel Data Scientist Interview Questions
Next questions
Rhombus PowerSQL 7-Day Rolling ComparisonMediumEvidation HealthCompute 7-Day Rolling AverageHardUberRolling 7-Day SQL WindowMedium