SELECT
  repo_name AS repository,
  EXACT_COUNT_DISTINCT(author.name) AS authors,
  EXACT_COUNT_DISTINCT(committer.name) AS committers,
  COUNT(*) AS commits
FROM
  [bigquery-public-data:github_repos.commits]
WHERE
  repo_name IN ( "torvalds/linux",
    "facebook/react-native",
    "ansible/ansible",
    "Microsoft/vscode",
    "angular/angular",
    "Automattic/wp-calypso",
    "tensorflow/tensorflow",
    "kubernetes/kubernetes")
  AND committer.date >= TIMESTAMP("2016-01-01 00:00:00")
  AND committer.date < TIMESTAMP("2017-01-01 00:00:00")
GROUP BY
  repository
ORDER BY
  commits DESC