Calculating Running Totals with Threshold Reset in SQL.

Running Total Count of Distinct Values in SQL Window

Mastering SQL Window Functions: A Guide to Running Totals and CTEs