Skip to content

Instantly share code, notes, and snippets.

@kalenjordan

kalenjordan/orders-by-month.sql

Created May 15, 2014 22:51
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kalenjordan/9459c7f45ad8f1512669 to your computer and use it in GitHub Desktop.
Save kalenjordan/9459c7f45ad8f1512669 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
orders-by-month.sql
SELECT DATE_FORMAT(o.created_at, "%b"), count(*)
FROM sales_flat_order AS o
WHERE created_at BETWEEN
DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 12 MONTH), "%Y-%m-01")
AND
LAST_DAY(DATE_SUB(NOW(), INTERVAL 1 MONTH))
GROUP BY DATE_FORMAT(o.created_at, "%m")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment