Using ARRAY_AGG in BigQuery

Almost everybody knows the usual standard SQL aggregation functions like SUM, MAX or AVG. In this short post, we're going to look at ARRAY_AGG: another useful aggregation function. So, what does it do? ARRAY_AGG allows us to aggregate multiple rows i...