blob: c4e6e645d8bf46daa830eb5a9f10595c293751d6 [file] [log] [blame]
SELECT
cast(actor['login'] as string),
count() AS c,
count(distinct cast(repo['name'] as string)) AS repos
FROM github_events
WHERE type = 'PushEvent'
GROUP BY cast(actor['login'] as string)
ORDER BY c DESC, 1, 3
LIMIT 50