sql server group by with grouping sets

SQL GROUPING SETS allows computing multiple GROUP BY clauses in a single statement.  The results of GROUPING SETS are the equivalent of UNION ALL of the specified groups.