Conditional Calculations in SQL: Using Case Statements to Create New Fields Based on Results of Another Field

Calculating Running Totals Based on Changes in Indicator Columns Using Group Row Numbers and Window Functions