Skip to content

Instantly share code, notes, and snippets.

@kalenjordan

kalenjordan/order-volume-by-hour.sql

Created July 30, 2014 17:02
Show Gist options
  • Save kalenjordan/0fafe5ba7c12bad061ae to your computer and use it in GitHub Desktop.
Save kalenjordan/0fafe5ba7c12bad061ae to your computer and use it in GitHub Desktop.
Download ZIP
Raw
order-volume-by-hour.sql
SELECT count(*), date_format(date_sub(created_at, INTERVAL 7 HOUR), "%h %p PST")
FROM sales_flat_order
# WHERE created_at > date_sub(now(), INTERVAL 1 year)
GROUP BY date_format(date_sub(created_at, INTERVAL 7 HOUR), "%h %p PST")
ORDER BY date_format(date_sub(created_at, INTERVAL 7 HOUR), "%H") ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment