dankohn · February 26, 2017 02:45
diff --git a/k8s_contributors.sql b/k8s_contributors.sql
 SELECT
  actor.login as contributor,
  COUNT(repo.name) AS commits,
 FROM
  [githubarchive:year.2016]
 WHERE
  type IN ("PushEvent") AND
  repo.name = "kubernetes/kubernetes"
 GROUP BY
  contributor
 ORDER BY
  commits DESC
 LIMIT
  100
diff --git a/results.csv b/results.csv
	SELECT
	actor.login as contributor,
	COUNT(repo.name) AS commits,
	FROM
	[githubarchive:year.2016]
	WHERE
	type IN ("PushEvent") AND
	repo.name = "kubernetes/kubernetes"
	GROUP BY
	contributor
	ORDER BY
	commits DESC
	LIMIT
	100