Skip to content

Instantly share code, notes, and snippets.

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

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

Select an option

Save atopal/5901106 to your computer and use it in GitHub Desktop.
number of users registering per day
# Shows number users registering per day
SELECT DATE(`auth_user`.`date_joined`), count(*)
FROM `auth_user`
WHERE DATE(`auth_user`.`date_joined`) > '2012-12-01'
GROUP BY DATE(`auth_user`.`date_joined`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment