You are building a sales summary query in a Fabric warehouse. The business wants a single result set that shows total sales aggregated by Region and Category, plus subtotals for each Region, plus a grand total across all rows — all returned by one query. Which T-SQL construct should you use in the GROUP BY clause?