CREATE STREAMING LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM sales_cleaned GROUP BY order_date

CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM STREAM(sales_cleaned) GROUP BY order_date

CREATE STREAMING TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date

CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date

CREATE STREAMING LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM STREAM(sales_cleaned) GROUP BY order_date