Octoverse 2016 - Repositories with most contributors (top 20)

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 = 'CommitCommentEvent'
    OR events.type = 'PushEvent'
    OR events.type = 'IssueCommentEvent'
    OR events.type = 'PullRequestEvent'
    OR events.type = 'PullRequestReviewCommentEvent'
    OR events.type = 'IssuesEvent'
GROUP BY
  1
ORDER BY
  2 DESC
LIMIT
  10