Moving Average (7-day or N-day)
Moving averages smooth time-series data and are used in finance, product analytics, and operations dashboards. The sliding window frame syntax (ROWS BETWEEN N PRECEDING AND CURRENT ROW) is a key window function skill.
Enable JavaScript for the full StreamPrep guide.