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