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".