anna-geller · July 28, 2023 07:49
diff --git a/02_duckdb_email.sql b/02_duckdb_email.sql
 CREATE DATABASE orders;
 CREATE TABLE orders.main.montly_orders as
    SELECT month(order_date) as order_month, sum(total) as total
    FROM read_csv_auto('s3://kestraio/monthly_orders/*.csv')
    GROUP BY 1
    ORDER BY 2 desc;
	CREATE DATABASE orders;
	CREATE TABLE orders.main.montly_orders as
	SELECT month(order_date) as order_month, sum(total) as total
	FROM read_csv_auto('s3://kestraio/monthly_orders/*.csv')
	GROUP BY 1
	ORDER BY 2 desc;