Skip to content

Instantly share code, notes, and snippets.

@maccman

maccman/repos_created_by_language.sql

Created January 26, 2014 16:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save maccman/8635419 to your computer and use it in GitHub Desktop.
Save maccman/8635419 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
repos_created_by_language.sql
SELECT repository_language, count(repository_language) AS repos_by_lang
FROM [githubarchive:github.timeline]
WHERE repository_fork == "false"
AND type == "CreateEvent"
AND PARSE_UTC_USEC(repository_created_at) >= PARSE_UTC_USEC('2013-01-01 00:00:00')
AND PARSE_UTC_USEC(repository_created_at) < PARSE_UTC_USEC('2013-12-30 00:00:00')
GROUP BY repository_language
ORDER BY repos_by_lang DESC
LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment