How to count occurences in Bigquery Array/Repeated Fields
In BigQuery, there is the concept of repeated fields and arrays. I was trying to figure out how to count how many entries in a table contain a certain value in that repeated column. And since the syntax [value] IN some_array is not valid, there is one extra that is needed. Suppose we have some data around freemium podcast platform. In this platform users can pay for an upgraded service, or listen for free....