Skip to content

Instantly share code, notes, and snippets.

@thedarsideofit

thedarsideofit/usuarios-por-mes.sql

Created May 3, 2018 12:17
Show Gist options
  • Save thedarsideofit/c61986a1c06ca512b3dd394840f0aae2 to your computer and use it in GitHub Desktop.
Save thedarsideofit/c61986a1c06ca512b3dd394840f0aae2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
usuarios-por-mes.sql
SELECT COUNT( ID ) AS usuarios, DATE_FORMAT( created_at, '%Y/%m' ) AS fecha
FROM `fos_user`
WHERE 1
GROUP BY DATE_FORMAT( created_at, '%Y/%m' )
LIMIT 0 , 30
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment