Cacher is the code snippet organizer for pro developers

-- Top ten Players who have played highest number of matches

SELECT TOP 10 Player_Name , 
		COUNT(*) As 'Matches_Played'
FROM
	Player_Match
INNER JOIN
	Player
ON Player_Match.Player_Id = Player.Player_Id

GROUP BY Player_Name

ORDER BY Matches_Played DESC