Skip to content

Instantly share code, notes, and snippets.

@atopal
Created July 1, 2013 14:42
Show Gist options
  • Select an option

  • Save atopal/5901428 to your computer and use it in GitHub Desktop.

Select an option

Save atopal/5901428 to your computer and use it in GitHub Desktop.
Number of new questions per day
SELECT DATE(`questions_question`.`created`), count(*)
FROM `questions_question`
WHERE DATE(`questions_question`.`created`) > '2012-12-01'
GROUP BY DATE(`questions_question`.`created`)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment