Skip to content

Instantly share code, notes, and snippets.

@atopal

atopal/gist:b1f8e1363385d88c98c7

Created May 17, 2015 13:28
Show Gist options
  • Save atopal/b1f8e1363385d88c98c7 to your computer and use it in GitHub Desktop.
Save atopal/b1f8e1363385d88c98c7 to your computer and use it in GitHub Desktop.
Download ZIP
All replies in Army of Awesome for a time frame by month
Raw
gistfile1.sql
SELECT `customercare_reply`.`created`, count(*)
FROM `customercare_reply`
WHERE `customercare_reply`.`created` BETWEEN '2015-01-01' AND '2015-05-01'
GROUP BY month(`customercare_reply`.`created`)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment