The best solution for pulling multiple levels of granularity over the same dataset in SQL Server is by using grouping sets. Microsoft official docs: https://learn ...