Advertisement
Guest User

Untitled

a guest
Feb 25th, 2017
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. SELECT
  2. repo.name AS repository,
  3. COUNT(repo.name) AS commits,
  4. EXACT_COUNT_DISTINCT(actor.login) AS contributors
  5. FROM
  6. [githubarchive:year.2016]
  7. WHERE
  8. type IN ("PushEvent")
  9. GROUP BY
  10. repository
  11. HAVING
  12. contributors > 9
  13. ORDER BY
  14. commits DESC
  15. LIMIT
  16. 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement