This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH distinct_commits AS ( | |
SELECT DISTINCT repo.name_s, actor.login_s | |
FROM github.events AS events | |
INNER JOIN github.events_actor AS actor ON (events.did = actor.did) | |
INNER JOIN github.events_repo AS repo ON (events.did = repo.did) | |
WHERE events.type_s = 'PushEvent' | |
) | |
SELECT name_s, count(*) | |
FROM distinct_commits | |
GROUP BY name_s | |
ORDER BY count DESC; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment