Skip to content

Instantly share code, notes, and snippets.

@harsha547

harsha547/SQL_Query_9.sql

Created December 18, 2016 21:33
Show Gist options
  • Save harsha547/098b0d7f54654914c4fea68ff6055e55 to your computer and use it in GitHub Desktop.
Save harsha547/098b0d7f54654914c4fea68ff6055e55 to your computer and use it in GitHub Desktop.
Download ZIP
Teams won margin over of 100 runs
Raw
SQL_Query_9.sql
-- Number of times team has won
-- marign over of 100 Runs
SELECT Team.Team_Name , Match.Win_Margin
FROM
Match
INNER JOIN
Win_By
ON Match.Win_Type = Win_By.Win_Id
INNER JOIN
Team
ON Match.Match_Winner = Team.Team_Id
WHERE Win_By.Win_Type = 'runs' AND Match.Win_Margin > 100
ORDER BY Match.Win_Margin 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