← All practice problems

Densify daily revenue then 3-day rolling average

working · sql🔒Walkthroughs

NEW

Densify daily revenue then 3-day rolling average

For a TRUE 3-day rolling average we need every day in range to exist — zero-revenue days included. Otherwise the average drifts upward by hiding gaps.

Generate a calendar spine from 2026-05-10 through 2026-05-25 (inclusive). LEFT JOIN paid orders aggregated by day, coalesce missing days to 0, then apply a trailing 3-row moving average over the densified series.

Round to 2 decimals.

Columns: day, daily_revenue, ma3. Sort by day ascending. Result has 16 rows (one per day in range).

Tables & sample data

orders

Loading preview…

query.sql

Loading…

Loading editor…