Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
SELECT actor, repository_owner, repository_name, repository_language, count(repository_name) AS pushes
FROM [publicdata:samples.github_timeline]
WHERE type='PushEvent'
AND repository_url IN
(SELECT repository_url FROM
(SELECT repository_url, MAX(repository_watchers)
FROM [publicdata:samples.github_timeline]
GROUP BY repository_url
HAVING MAX(repository_watchers) > 1000))
AND PARSE_UTC_USEC(created_at) >= PARSE_UTC_USEC('2012-01-01 00:00:00')
AND PARSE_UTC_USEC(created_at) < PARSE_UTC_USEC('2013-01-01 00:00:00')
GROUP BY actor, repository_owner, repository_name, repository_language;
-- 377 repos, 790 users
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment