Using SQL LAG Function to Calculate Sums of Consecutive Rows

Duplicating Rows in a Dataset Based on Multiple Conditions Using Recursive CTEs