Learning Google BigQuery

GROUP BY 

The GROUP BY statement is used to create an aggregation within a query. For instance, a query might be created to aggregate a dimension and to apply an arithmetic function to a metric. This is a common use case, especially when analysts and administrators aim to make data more efficient in a database. Example queries for GROUP BY are provided under the BigQuery SQL functions topic in this chapter.