I just learned of using the grouping sets clause and I believe I can re write one of my old queries. Currently, it is a union of 5 different groupings coming from a CTE. I understand that I should be easily able to change that into the different hierarchies they are being grouped into with grouping sets of even rollup, but I need to specify a literal at each level or grouping. I can't show you my actual code, but I have an example below.I just learned of using the grouping sets claus