Using ARRAY_CONCAT_AGG() in BigQuery

If you're working with ARRAYS in BigQuery, you might need to combine two arrays into one at some point in time. That's why I want to showcase an interesting function - ARRAY_CONCAT_AGG. What does it do? It's an aggregation function, it allows us to s...