Cacher is the code snippet organizer for pro developers

-- Number of Players participated in Indian Player League by respective Countries.
-- Atleast those who played a single match.

SELECT Country.Country_Name , 
	   Count(*) As "Players"
FROM 
	   Player
INNER JOIN 
       Country
ON 
      Player.Country_Name = Country.Country_Id
GROUP BY Country.Country_Name
ORDER BY Players DESC