Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Use Window Functions For Rolling Averages

Medium
MediumSQL & Data ManipulationWindow FunctionsLag/LeadRunning Totals

Problem

How would you calculate rolling averages using window functions?

Practicing as: Data Scientist interview at Otter.ai

Hi, I'll play your Otter.ai 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
Next questions
Impact Recruitment GroupRolling Average with Window FunctionsMediumHKT ServicesWindow Functions and Rolling AverageMediumMoody'sSQL Rolling Averages With WindowsMedium