mediumMeta Amazon Snowflake

Compute a 7-day moving average and other rolling aggregates with SQL window frames.

The subtle part of rolling aggregates is the window frame clause, especially ROWS vs RANGE. The signal is the right frame for a moving window and the tied-rows gotcha that corrupts running totals.

Updated Sep 2026 · Grounded in real GenAI, LLM, and AI/ML engineering interview loops and written to a senior-engineer editorial bar.

The subtle part of rolling aggregates is the window frame clause, especially ROWS vs RANGE. The signal is the right frame for a moving window and the tied-rows gotcha that corrupts running totals.

more free answers with an account · no card

UP NEXT ON YOUR JOURNEY

Next in this trackHow do you compute percentiles, medians, and quantile buckets in SQL?Next in this trackHow do you handle schema evolution in a data pipeline or lakehouse without breaking consumers?Next in this trackHow do you join two streams (or a stream to a table) in a streaming system?

DISCUSSION · 0

No comments yet — be the first to share your approach.