Skip to content

Instantly share code, notes, and snippets.

@harsha547

harsha547/SQL_Query_7.sql

Created December 18, 2016 20:22
Show Gist options
  • Save harsha547/1d7cf3f07ddf2506f28c0728194fd588 to your computer and use it in GitHub Desktop.
Save harsha547/1d7cf3f07ddf2506f28c0728194fd588 to your computer and use it in GitHub Desktop.
Download ZIP
Top 12 Players who have most man of the matches in Indian Premier League ( 2008 - 2016 )
Raw
SQL_Query_7.sql
-- Top 12 players who have most man of the matches in
-- Indian Premier League ( 2008 - 2016 )
SELECT TOP 12 Player.Player_Name ,
COUNT(*) As 'Man_Of_The_Matches'
FROM
Match
INNER JOIN
Player
ON
Match.Man_of_the_Match = Player.Player_Id
GROUP BY Player.Player_Name
ORDER BY Man_Of_The_Matches DESC
@harsha547
Copy link
Author

Result 👍

image

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