Skip to content

Instantly share code, notes, and snippets.

@atopal

atopal/gist:4985044

Created February 19, 2013 11:31
Show Gist options
  • Save atopal/4985044 to your computer and use it in GitHub Desktop.
Save atopal/4985044 to your computer and use it in GitHub Desktop.
Download ZIP
number of positive question votes per day
Raw
gistfile1.sql
SELECT DATE(`questions_answervote`.`created`) as days, count(*) as number_of_pos_votes
FROM `questions_answervote`
WHERE `questions_answervote`.`helpful`=1
AND `questions_answervote`.`created` BETWEEN '2012-01-01 0' AND '2013-02-17 0'
GROUP BY DATE(`questions_answervote`.`created`)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment