GROUPING SETS, CUBE, and ROLLUP
is: This query will return the following results: SalesPerson Region SUM(Amount) John East 100 John West 150 Jane East 200 Jane West 250 John NULL 250 Jane NULL 450 NULL….
is: This query will return the following results: SalesPerson Region SUM(Amount) John East 100 John West 150 Jane East 200 Jane West 250 John NULL 250 Jane NULL 450 NULL….