How to Perform SQL Insert/Update from Another Table Based on a Condition Using the MERGE Statement

Understanding SQL Grouping with a Created Column

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