A practical exercise working with ARRAYS and correlated subqueries in BigQuery

Here's an interesting SQL problem, similar to one I had to solve the other day. It involves some of our favourite BigQuery ARRAYS, but also correlated subqueries. Say we have a table events that represents some events, together with the city and the ...