Window Frame Rows — Solution & ExplanationProblems / Window Frame Rows / EditorialApproachA rolling 7-day sum uses a fixed-size row window frame.

Frame: ROWS BETWEEN 6 PRECEDING AND CURRENT ROW includes the current row plus the 6 rows before it.

Partial windows: For the first row, only itself is included. The second row includes 2 rows, etc. The window reaches its full 7-row size on the 7th row.

ROWS vs RANGE: ROWS counts physical row positions, which is what we want here. RANGE would compare actual values and could behave differently with gaps.

This pattern is essential in analytics: rolling sums, rolling averages, and rolling counts over fixed-size windows.Hints

ROWS BETWEEN 6 PRECEDING AND CURRENT ROW creates a 7-row window (6 before + current).

Don't confuse ROWS with RANGE — ROWS counts physical rows, RANGE uses value differences.

In PySpark, use rowsBetween(-6, Window.currentRow).

Solve Window Frame Rows yourself →