I have a standard SQL query of the following structure
SELECT a, ARRAY_AGG(STRUCT(x,y,z))
FROM t
GROUP BY a
How can write the same query in legacy SQL?
I have a standard SQL query of the following structure
SELECT a, ARRAY_AGG(STRUCT(x,y,z))
FROM t
GROUP BY a
How can write the same query in legacy SQL?