STRING_AGG

1
SELECT
2
  customer_id,
3
  STRING_AGG(product_name, ', ') as purchased_products
4
FROM `project.dataset.orders`
5
GROUP BY customer_id
6
LIMIT 3;

1
SELECT
2
  department,
3
  STRING_AGG(employee_name, '; ' ORDER BY hire_date) as employees_by_seniority
4
FROM `project.dataset.employees`
5
GROUP BY department;

1
SELECT
2
  order_date,
3
  STRING_AGG(DISTINCT category, ', ' ORDER BY category) as categories_sold
4
FROM `project.dataset.sales`
5
GROUP BY order_date
6
ORDER BY order_date DESC
7
LIMIT 3;

1
SELECT
2
  user_id,
3
  '[' || STRING_AGG('"' || tag || '"', ', ') || ']' as tags_json
4
FROM `project.dataset.user_tags`
5
GROUP BY user_id;