Stampede-GithuQuery-PostgreSQL-E

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;