Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling Averages in SQL

Hard
HardSQL & Data ManipulationWindow FunctionsDate FunctionsRunning Totals

Problem

How would you write a query to calculate rolling averages for user activity over time?

Practicing as: Data Analyst interview at Andela Products

Hi, I'll play your Andela Products interviewer for the Data Analyst 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
IndeedRolling Average QueryMediumMoody'sSQL Rolling Averages With WindowsMediumKpmg UsSQL Rolling 7-Day AverageMedium