Skip to content

Instantly share code, notes, and snippets.

@michaelhood

michaelhood/github-bigquery.sql

Last active December 12, 2015 05:38
Show Gist options
  • Save michaelhood/4722617 to your computer and use it in GitHub Desktop.
Save michaelhood/4722617 to your computer and use it in GitHub Desktop.
Download ZIP
regexp match leaderboard bigquery for githubarchive
Raw
github-bigquery.sql
SELECT repository_url, repository_description, COUNT(*) AS c
FROM [githubarchive:github.timeline]
WHERE REGEXP_MATCH(repository_name, r'github([^\.]|$)')
GROUP BY repository_url, repository_description
ORDER BY c DESC
LIMIT 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment