bq_nest12

bq_nest12.txt

SELECT 
  main.object_id
  , title
  , artist_display_name 
  , ARRAY_TO_STRING(ARRAY_AGG(lA.description), ';') AS description
FROM `bigquery-public-data.the_met.objects` AS main
INNER JOIN 
  `bigquery-public-data.the_met.vision_api_data` AS api
ON main.object_id = api.object_id
CROSS JOIN UNNEST(labelAnnotations) lA 
WHERE
  LOWER(artist_display_name) = 'claude monet'
GROUP BY
  1, 2, 3