/* 09. Most Contributed Repositories */

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