SET "date" = TO_DATE(data.orderDate);
// GENERATED @ 2020-10-12T04:13:03.089790Z
SELECT PARTITION_TIME("date") AS _date_1:TIMESTAMP,
AGGREGATION_TIME() AS processing_time:TIMESTAMP,
data.items[].itemId AS items_id:STRING,
"date" AS _date:TIMESTAMP,
COUNT(*) AS "count":DOUBLE,
SUM(data.items[].price) AS sum_items_price:DOUBLE,
AVG(data.items[].price) AS avg_items_price:DOUBLE
GROUP BY data.items[].itemId,