How can we compute a 7-day moving average of daily order revenue?
ROWS BETWEEN 6 PRECEDING AND CURRENT ROW calculates a rolling 7-row moving window average.
Smoothing daily revenue volatility, 7-day moving averages in financial charts, trend lines.
SELECT
order_date,
amount,
AVG(amount) OVER (
ORDER BY order_date
ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
) AS seven_day_average
FROM orders;Practice typing production-grade SQL code for Moving Average.