Stampede-GithuQuery-PostgreSQL-A

SELECT		repo.name_s, count(*)
FROM 		github.events AS events 
        		INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
        		INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
WHERE		events.type_s = 'IssuesEvent' AND payload.action_s = 'opened'
GROUP BY	repo.name_s
ORDER BY	count desc;