Issues Opened, based on https://medium.com/google-cloud/analyzing-github-issues-and-comments-with-bigquery-c41410d3308#.7wh56zddk

issues.sql

SELECT
  repo.name,
  ROUND(COUNT(*)/EXACT_COUNT_DISTINCT(actor.login),2) comments_per_author,
  EXACT_COUNT_DISTINCT(actor.login ) authors,
  COUNT(*) comments
FROM
  [githubarchive:year.2016]
WHERE
  type IN ('IssueCommentEvent')
  AND actor.login NOT IN (
  SELECT
    actor.login
  FROM (
    SELECT
      actor.login,
      COUNT(*) c
    FROM
      [githubarchive:year.2016]
    WHERE
      type IN ('IssueCommentEvent')
    GROUP BY
      1
    HAVING
      c>1000
    ORDER BY
      2 DESC ))
GROUP BY
  1
HAVING
  authors>400
ORDER BY
  4 DESC
LIMIT
  50

results.csv