Introduction
Group aggregation is widely used for large-scale data analysis (OLAP). Unlike regular SELECT
queries , it changes the cardinality of result. Here we give an example, columns appearing after GROUP BY
are the "grouping columns", and columns appearing after SELECT
must be either the "grouping columns" or "aggregations".