Advertisement
Guest User

Most Contributed Repositories

a guest
Oct 13th, 2019
277
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.18 KB | None | 0 0
  1. SELECT TOP(5) r.Id, r.[Name], COUNT(c.Id) AS Commits
  2. FROM Commits AS c
  3. JOIN Repositories AS r ON c.RepositoryId = r.Id
  4. GROUP BY r.Id, r.[Name]
  5. ORDER BY Commits DESC, r.Id, r.[Name]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement