Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Rolling 3-Day Average Query

Medium
SQL & Data ManipulationWindow FunctionstransactionsRunning Totals
Asked 2mo ago|
Tiger Analytics
Tiger Analytics
Asked 1 times

Problem

Given a transaction dataset, write a query to find the rolling 3-day average of sales for each product category.

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
Tiger Analytics Business Analyst Interview Questions
Next questions
AmplifySQL Rolling Average QueryMediumBayerRolling 7-Day Average by RegionMediumAscendionRolling 30-Day Average TransactionsHard
0 / ~200 words