Most Contributed Repositories

SELECT TOP(5) r.Id, r.[Name], COUNT(c.Id) AS Commits
FROM Commits AS c
JOIN Repositories AS r ON c.RepositoryId = r.Id
GROUP BY r.Id, r.[Name]
ORDER BY Commits DESC, r.Id, r.[Name]