Group by ROLLUP and CUBE

Two important syntactic shortcuts exist to concisely specify common grouping for prefixes. The first of these patterns is called ROLLUP, and the second is called CUBE.