Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
trying to think about how to solve the problem was join the two tables together and group the data by shop_id and article_id, like this: Image by author. For those of you not familiar with nested structures in BigQuery, this might look a bit weird at first, so here is a detailed explanation of how