SQL Ranking Based on Condition

SQL Running Total with Cumulative Flag Calculation Using Common Table Expression