Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- repo.name AS repository,
- COUNT(repo.name) AS commits,
- EXACT_COUNT_DISTINCT(actor.login) AS contributors
- FROM
- [githubarchive:year.2016]
- WHERE
- type IN ("PushEvent")
- GROUP BY
- repository
- HAVING
- contributors > 9
- ORDER BY
- commits DESC
- LIMIT
- 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement