harsha547
4/8/2017 - 9:17 PM

Sixes Scored by Chris Gayle in Chinnaswamy Stadium ( Bangalore )

Sixes Scored by Chris Gayle in Chinnaswamy Stadium ( Bangalore )

-- Sixes Scored by Chris Gayle in Chinnaswamy Stadium

SELECT 'Chris_Gayle' As Player , COUNT(*) As ' Sixes_Scored'
	FROM Ball_by_Ball A
	INNER JOIN Batsman_Scored B
	ON CONCAT(A.Match_Id,A.Over_Id,A.Ball_Id,A.Innings_No)
						= CONCAT(B.Match_Id,B.Over_Id,B.Ball_Id,B.Innings_No)
						
	INNER JOIN Player C
	ON A.Striker = C.Player_Id
	INNER JOIN Match D
	ON A.Match_Id = D.Match_Id
	INNER JOIN Venue E
	ON D.Venue_Id = E.Venue_Id
	WHERE B.Runs_Scored = 6 AND A.Striker = 162 AND D.Venue_Id = 1 ;
  
  -- Linkedin Profile : https://www.linkedin.com/in/harshasannareddy/