How to calculate Subtotals in SQL Queries using SQL Server 2019
Briefly