Skip to content

Instantly share code, notes, and snippets.

@matburt

matburt/gist:ac3b5fbb25f99678cdb5904d3fd09b85

Last active September 19, 2016 12:29
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 matburt/ac3b5fbb25f99678cdb5904d3fd09b85 to your computer and use it in GitHub Desktop.
Save matburt/ac3b5fbb25f99678cdb5904d3fd09b85 to your computer and use it in GitHub Desktop.
Download ZIP
Octoverse 2016 - Contributions without comments
Raw
gistfile1.sql
SELECT
events.repo.name AS events_repo_name,
COUNT(DISTINCT events.actor.id) AS events_actor_count
FROM (
SELECT
*
FROM TABLE_DATE_RANGE([githubarchive:day.],TIMESTAMP('2015-09-01'),TIMESTAMP('2016-08-31'))) AS events
WHERE
events.type = 'PushEvent'
OR events.type = 'PullRequestEvent'
OR events.type = 'IssuesEvent'
GROUP BY
1
ORDER BY
2 DESC
LIMIT
20
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment