Skip to content

Instantly share code, notes, and snippets.

@harsha547

harsha547/SQL_Query_2.sql

Created December 17, 2016 18:42
Show Gist options
  • Save harsha547/ce6ef8d431db21b31ef24ee0c9065e08 to your computer and use it in GitHub Desktop.
Save harsha547/ce6ef8d431db21b31ef24ee0c9065e08 to your computer and use it in GitHub Desktop.
Download ZIP
-- Number of Players participated in Indian Player League by respective Countries. At least those who played a single match.
Raw
SQL_Query_2.sql
-- 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
@harsha547
Copy link
Author

Solution 👍

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment