SQL Query for Calculating Daily, Monthly, Yearly, and Group Totals from an Existing Table

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

Dynamic Pivot Queries for Summing Values by Month in SQL Server

Understanding SQL Grouping with a Created Column