You have analytics data stored in BigQuery. You need an efficient way to compute values across a group of rows and return a single result for each row.