Running Total Count of Distinct Values in SQL Window

Optimizing SQL Queries: How to Calculate Cumulative Totals with Corrected Contributions

Calculating Running Totals with Threshold Reset in SQL.