SQL Window Frames

What & Why

A window frame narrows an ordered partition with ROWS or RANGE boundaries such as unbounded preceding and current row. Frames distinguish a running metric from a moving metric and prevent surprising LAST_VALUE or cumulative results.

See How It Works

SELECT
  date_day,
  dau,
  SUM(dau) OVER (
    ORDER BY date_day
    ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
  ) AS rolling_7_row_dau
FROM growth.daily_active_users
ORDER BY date_day;