Running Total Count of Distinct Values in SQL Window

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