Skip to content

Instantly share code, notes, and snippets.

@anna-geller

anna-geller/02_monthly_report.sql

Created July 28, 2023 07:49
Show Gist options
  • Save anna-geller/4a602ef0acf900b0e5d7c72d98200fce to your computer and use it in GitHub Desktop.
Save anna-geller/4a602ef0acf900b0e5d7c72d98200fce to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment