harsha547
12/18/2016 - 9:33 PM

Teams won margin over of 100 runs

Teams won margin over of 100 runs

-- 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