02_monthly_report.sql

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;