ARRAY_AGG

1
SELECT
2
  customer_id,
3
  ARRAY_AGG(product_id) as product_ids
4
FROM `project.dataset.orders`
5
GROUP BY customer_id
6
LIMIT 3;

1
SELECT
2
  category,
3
  ARRAY_AGG(product_name ORDER BY sales_count DESC LIMIT 3) as top_3_products
4
FROM `project.dataset.products`
5
GROUP BY category;

1
SELECT
2
  department,
3
  ARRAY_AGG(
4
    STRUCT(employee_name, salary, hire_date)
5
    ORDER BY salary DESC
6
    LIMIT 5
7
  ) as top_paid_employees
8
FROM `project.dataset.employees`
9
GROUP BY department;

1
SELECT
2
  user_id,
3
  ARRAY_AGG(DISTINCT category ORDER BY category) as unique_categories
4
FROM `project.dataset.user_activity`
5
GROUP BY user_id;