Skip to content

Instantly share code, notes, and snippets.

@brndnmtthws

brndnmtthws/bigquery.sql Secret

Created June 14, 2016 17:02
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 brndnmtthws/6defb2e3e9e99d2d72cbdfcd29ce0f30 to your computer and use it in GitHub Desktop.
Save brndnmtthws/6defb2e3e9e99d2d72cbdfcd29ce0f30 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bigquery.sql
SELECT repository_name, count(1) as count
FROM [githubarchive:github.timeline]
WHERE payload_pull_request_user_login ='brndnmtthws' or payload_pull_request_user_login = 'brndnmtthws' or payload_comment_user_login = 'brndnmtthws' or payload_commit_email ='brenden@diddyinc.com' or payload_commit_email ='brenden.matthews@airbnb.com' or payload_commit_email = 'brenden@mesosphere.io'
GROUP BY repository_name order by count desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment