How to add a subtotal row in sql

sql rollup multiple rows
running subtotal in sql
sql subtotal by month
group by sql
roll over in sql
sql server grouping sets
mssql with rollup grouping
cube sql w3schools