CREATE TABLE [Player] ( [Player_Id] integer NOT NULL, [Player_Name] varchar(400) NOT NULL COLLATE NOCASE, [DOB] datetime COLLATE NOCASE, [Batting_hand] integer NOT NULL, [Bowling_skill] integer, [Country_Name] integer NOT NULL, PRIMARY KEY ([Player_Id]), FOREIGN KEY ([Batting_hand]) REFERENCES [Batting_Style]([Batting_Id]), FOREIGN KEY ([Bowling_skill]) REFERENCES [Bowling_Style]([Bowling_Id]), FOREIGN KEY ([Country_Name]) REFERENCES [Country]([Country_Id]) ); CREATE TABLE [Extra_Runs] ( [Match_Id] integer NOT NULL, [Over_Id] integer NOT NULL, [Ball_Id] integer NOT NULL, [Extra_Type_Id] integer NOT NULL, [Extra_Runs] integer NOT NULL, [Innings_No] integer NOT NULL, PRIMARY KEY ([Match_Id], [Over_Id], [Ball_Id], [Innings_No]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Extra_Type_Id]) REFERENCES [Extra_Type]([Extra_Id]) ); CREATE TABLE [Batsman_Scored] ( [Match_Id] integer NOT NULL, [Over_Id] integer NOT NULL, [Ball_Id] integer NOT NULL, [Runs_Scored] integer NOT NULL, [Innings_No] integer NOT NULL, PRIMARY KEY ([Match_Id], [Over_Id], [Ball_Id], [Innings_No]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Over_Id]) ); CREATE TABLE [Batting_Style] ( [Batting_Id] integer NOT NULL, [Batting_hand] varchar(200) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Batting_Id]) ); CREATE TABLE [Bowling_Style] ( [Bowling_Id] integer NOT NULL, [Bowling_skill] varchar(200) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Bowling_Id]) ); CREATE TABLE [Country] ( [Country_Id] integer NOT NULL, [Country_Name] varchar(200) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Country_Id]) ); CREATE TABLE [Season] ( [Season_Id] integer NOT NULL, [Man_of_the_Series] integer NOT NULL, [Orange_Cap] integer NOT NULL, [Purple_Cap] integer NOT NULL, [Season_Year] integer, PRIMARY KEY ([Season_Id]), FOREIGN KEY ([Man_of_the_Series]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Orange_Cap]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Purple_Cap]) REFERENCES [Player]([Player_Id]) ); CREATE TABLE [City] ( [City_Id] integer NOT NULL, [City_Name] varchar(200) NOT NULL COLLATE NOCASE, [Country_id] integer, PRIMARY KEY ([City_Id]), FOREIGN KEY ([Country_id]) REFERENCES [Country]([Country_Id]) ); CREATE TABLE [Outcome] ( [Outcome_Id] integer NOT NULL, [Outcome_Type] varchar(200) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Outcome_Id]) ); CREATE TABLE [Win_By] ( [Win_Id] integer NOT NULL, [Win_Type] varchar(200) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Win_Id]) ); CREATE TABLE [Wicket_Taken] ( [Match_Id] integer NOT NULL, [Over_Id] integer NOT NULL, [Ball_Id] integer NOT NULL, [Player_Out] integer NOT NULL, [Kind_Out] integer NOT NULL, [Fielders] integer, [Innings_No] integer NOT NULL, PRIMARY KEY ([Match_Id], [Over_Id], [Ball_Id], [Innings_No]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Ball_Id]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Innings_No]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Match_Id]), FOREIGN KEY ([Match_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Over_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Ball_Id]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Innings_No]) REFERENCES [Ball_by_Ball]([Over_Id]), FOREIGN KEY ([Kind_Out]) REFERENCES [Out_Type]([Out_Id]), FOREIGN KEY ([Player_Out]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Fielders]) REFERENCES [Player]([Player_Id]) ); CREATE TABLE [Venue] ( [Venue_Id] integer NOT NULL, [Venue_Name] varchar(450) NOT NULL COLLATE NOCASE, [City_Id] integer, PRIMARY KEY ([Venue_Id]), FOREIGN KEY ([City_Id]) REFERENCES [City]([City_Id]) ); CREATE TABLE [Extra_Type] ( [Extra_Id] integer NOT NULL, [Extra_Name] varchar(150) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Extra_Id]) ); CREATE TABLE [Out_Type] ( [Out_Id] integer NOT NULL, [Out_Name] varchar(250) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Out_Id]) ); CREATE TABLE [Toss_Decision] ( [Toss_Id] integer NOT NULL, [Toss_Name] varchar(50) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Toss_Id]) ); CREATE TABLE [Umpire] ( [Umpire_Id] integer NOT NULL, [Umpire_Name] varchar(350) NOT NULL COLLATE NOCASE, [Umpire_Country] integer NOT NULL, PRIMARY KEY ([Umpire_Id]), FOREIGN KEY ([Umpire_Country]) REFERENCES [Country]([Country_Id]) ); CREATE TABLE [Team] ( [Team_Id] integer NOT NULL, [Team_Name] varchar(450) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Team_Id]) ); CREATE TABLE [Ball_by_Ball] ( [Match_Id] integer NOT NULL, [Over_Id] integer NOT NULL, [Ball_Id] integer NOT NULL, [Innings_No] integer NOT NULL, [Team_Batting] integer NOT NULL, [Team_Bowling] integer NOT NULL, [Striker_Batting_Position] integer NOT NULL, [Striker] integer NOT NULL, [Non_Striker] integer NOT NULL, [Bowler] integer NOT NULL, PRIMARY KEY ([Match_Id], [Over_Id], [Ball_Id], [Innings_No]), FOREIGN KEY ([Match_Id]) REFERENCES [Match]([Match_Id]), FOREIGN KEY ([Striker]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Non_Striker]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Bowler]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Team_Batting]) REFERENCES [Team]([Team_Id]), FOREIGN KEY ([Team_Bowling]) REFERENCES [Team]([Team_Id]) ); CREATE TABLE [Match] ( [Match_Id] integer NOT NULL, [Team_1] integer NOT NULL, [Team_2] integer NOT NULL, [Match_Date] datetime NOT NULL COLLATE NOCASE, [Season_Id] integer NOT NULL, [Venue_Id] integer NOT NULL, [Toss_Winner] integer NOT NULL, [Toss_Decide] integer NOT NULL, [Win_Type] integer NOT NULL, [Win_Margin] integer, [Outcome_type] integer NOT NULL, [Match_Winner] integer, [Man_of_the_Match] integer, PRIMARY KEY ([Match_Id]), FOREIGN KEY ([Outcome_type]) REFERENCES [Outcome]([Outcome_Id]), FOREIGN KEY ([Man_of_the_Match]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Season_Id]) REFERENCES [Season]([Season_Id]), FOREIGN KEY ([Team_1]) REFERENCES [Team]([Team_Id]), FOREIGN KEY ([Team_2]) REFERENCES [Team]([Team_Id]), FOREIGN KEY ([Toss_Winner]) REFERENCES [Team]([Team_Id]), FOREIGN KEY ([Match_Winner]) REFERENCES [Team]([Team_Id]), FOREIGN KEY ([Toss_Decide]) REFERENCES [Toss_Decision]([Toss_Id]), FOREIGN KEY ([Venue_Id]) REFERENCES [Venue]([Venue_Id]), FOREIGN KEY ([Win_Type]) REFERENCES [Win_By]([Win_Id]) ); CREATE TABLE [Role] ( [Role_Id] integer NOT NULL, [Role_Desc] varchar(150) NOT NULL COLLATE NOCASE, PRIMARY KEY ([Role_Id]) ); CREATE TABLE [Player_Match] ( [Match_Id] integer NOT NULL, [Player_Id] integer NOT NULL, [Role_Id] integer NOT NULL, [Team_Id] integer, PRIMARY KEY ([Match_Id], [Player_Id]), FOREIGN KEY ([Match_Id]) REFERENCES [Match]([Match_Id]), FOREIGN KEY ([Player_Id]) REFERENCES [Player]([Player_Id]), FOREIGN KEY ([Role_Id]) REFERENCES [Role]([Role_Id]), FOREIGN KEY ([Team_Id]) REFERENCES [Team]([Team_Id]) ); INSERT INTO Ball_by_Ball VALUES (336002,9,5,1,1,7,5,4,3,149); INSERT INTO Ball_by_Ball VALUES (392237,1,2,1,6,2,2,41,40,14); INSERT INTO Ball_by_Ball VALUES (336015,2,2,2,2,1,2,51,130,84); INSERT INTO Ball_by_Ball VALUES (392235,16,2,1,6,5,4,135,110,31); INSERT INTO Ball_by_Ball VALUES (829754,6,1,2,2,5,3,110,8,310); INSERT INTO Ball_by_Ball VALUES (501258,6,4,2,6,3,2,187,292,201); INSERT INTO Ball_by_Ball VALUES (980988,18,5,2,6,11,5,420,351,460); INSERT INTO Ball_by_Ball VALUES (598013,12,6,2,2,1,1,162,110,151); INSERT INTO Ball_by_Ball VALUES (501224,4,4,2,1,9,3,40,214,81); INSERT INTO Ball_by_Ball VALUES (392218,2,4,1,2,5,2,7,9,190); INSERT INTO Ball_by_Ball VALUES (980910,16,4,1,4,13,5,62,409,14); INSERT INTO Ball_by_Ball VALUES (501217,6,6,1,8,4,2,42,26,210); INSERT INTO Ball_by_Ball VALUES (829790,1,5,1,2,4,1,162,8,367); INSERT INTO Ball_by_Ball VALUES (981010,15,6,1,4,12,2,185,329,430); INSERT INTO Ball_by_Ball VALUES (501214,8,4,1,5,1,2,6,266,276); INSERT INTO Ball_by_Ball VALUES (335992,3,6,2,5,4,3,69,32,66); INSERT INTO Ball_by_Ball VALUES (392207,20,4,1,3,5,3,21,20,126); INSERT INTO Ball_by_Ball VALUES (548385,19,1,1,3,6,6,71,185,296); INSERT INTO Ball_by_Ball VALUES (501240,4,5,1,10,5,2,96,46,32); INSERT INTO Ball_by_Ball VALUES (829816,6,2,1,5,1,2,32,85,276); INSERT INTO Ball_by_Ball VALUES (734040,14,5,2,3,2,4,20,303,27); INSERT INTO Ball_by_Ball VALUES (733996,3,2,2,2,4,3,8,17,367); INSERT INTO Ball_by_Ball VALUES (729306,7,1,1,11,6,2,254,42,293); INSERT INTO Ball_by_Ball VALUES (734024,10,1,2,4,6,4,320,62,154); INSERT INTO Ball_by_Ball VALUES (548325,4,4,2,1,5,2,40,9,196); INSERT INTO Ball_by_Ball VALUES (419145,9,1,2,2,6,3,158,9,89); INSERT INTO Ball_by_Ball VALUES (501230,13,1,2,5,9,1,32,192,121); INSERT INTO Ball_by_Ball VALUES (733992,4,2,2,3,4,2,2,21,357); INSERT INTO Ball_by_Ball VALUES (419114,13,4,1,2,1,7,46,9,191); INSERT INTO Ball_by_Ball VALUES (729284,7,5,1,1,7,3,96,9,50); INSERT INTO Ball_by_Ball VALUES (501247,13,5,2,1,9,2,216,87,259); INSERT INTO Ball_by_Ball VALUES (598028,2,3,2,2,5,1,135,162,77); INSERT INTO Ball_by_Ball VALUES (829714,20,2,2,4,5,10,392,395,350); INSERT INTO Ball_by_Ball VALUES (336021,15,2,2,4,2,1,100,139,15); INSERT INTO Ball_by_Ball VALUES (598041,11,2,1,2,5,4,110,8,335); INSERT INTO Ball_by_Ball VALUES (419148,12,4,2,5,4,3,31,183,161); INSERT INTO Ball_by_Ball VALUES (734012,1,5,2,4,11,2,62,345,299); INSERT INTO Ball_by_Ball VALUES (392233,15,3,2,8,1,3,178,56,83); INSERT INTO Ball_by_Ball VALUES (548378,12,5,2,8,5,1,331,154,39); INSERT INTO Ball_by_Ball VALUES (733988,11,1,1,7,2,4,57,221,296); INSERT INTO Ball_by_Ball VALUES (980992,17,2,1,2,13,3,110,8,35); INSERT INTO Ball_by_Ball VALUES (980952,6,3,2,7,1,3,208,57,346); INSERT INTO Ball_by_Ball VALUES (392243,13,2,2,2,3,2,96,6,186); INSERT INTO Ball_by_Ball VALUES (980916,7,5,1,12,13,2,303,158,35); INSERT INTO Ball_by_Ball VALUES (829730,5,4,1,4,6,1,185,41,191); INSERT INTO Ball_by_Ball VALUES (336025,8,1,2,8,6,4,57,97,89); INSERT INTO Ball_by_Ball VALUES (548337,4,6,2,3,5,1,23,303,309); INSERT INTO Ball_by_Ball VALUES (829774,11,5,1,7,5,4,57,208,377); INSERT INTO Ball_by_Ball VALUES (598032,11,7,2,10,2,6,253,306,83); INSERT INTO Ball_by_Ball VALUES (598043,9,5,1,3,10,3,21,23,106); INSERT INTO Ball_by_Ball VALUES (980906,10,5,2,12,7,3,158,85,50); INSERT INTO Ball_by_Ball VALUES (734030,10,1,1,4,7,3,100,345,456); INSERT INTO Ball_by_Ball VALUES (392204,20,5,2,2,1,5,11,96,162); INSERT INTO Ball_by_Ball VALUES (598017,20,5,2,3,2,8,350,35,61); INSERT INTO Ball_by_Ball VALUES (981018,5,6,1,13,2,5,147,88,140); INSERT INTO Ball_by_Ball VALUES (392187,18,1,1,2,5,8,14,6,38); INSERT INTO Ball_by_Ball VALUES (548311,15,2,2,7,3,5,275,208,201); INSERT INTO Ball_by_Ball VALUES (598024,10,3,2,7,5,6,208,88,255); INSERT INTO Ball_by_Ball VALUES (598075,1,6,2,7,3,2,207,147,364); INSERT INTO Ball_by_Ball VALUES (419169,13,3,2,2,8,2,6,158,256); INSERT INTO Ball_by_Ball VALUES (734044,7,2,1,6,4,5,87,158,392); INSERT INTO Ball_by_Ball VALUES (336012,18,3,2,8,3,5,70,58,119); INSERT INTO Ball_by_Ball VALUES (729314,7,1,2,6,7,2,185,355,372); INSERT INTO Ball_by_Ball VALUES (336034,6,3,2,3,2,2,107,17,9); INSERT INTO Ball_by_Ball VALUES (392194,1,2,2,3,6,1,17,18,223); INSERT INTO Ball_by_Ball VALUES (981000,3,6,2,2,1,1,162,8,334); INSERT INTO Ball_by_Ball VALUES (336039,16,1,2,8,2,4,57,55,94); INSERT INTO Ball_by_Ball VALUES (598042,6,3,1,7,4,1,147,88,321); INSERT INTO Ball_by_Ball VALUES (734026,12,1,2,11,2,2,187,42,382); INSERT INTO Ball_by_Ball VALUES (734002,15,3,1,4,1,1,41,320,67); INSERT INTO Ball_by_Ball VALUES (419137,3,2,1,4,7,3,214,100,210); INSERT INTO Ball_by_Ball VALUES (829782,1,4,1,5,6,2,32,85,15); INSERT INTO Ball_by_Ball VALUES (598056,19,6,1,3,11,3,21,35,94); INSERT INTO Ball_by_Ball VALUES (598023,6,2,2,10,11,4,178,306,84); INSERT INTO Ball_by_Ball VALUES (501264,15,2,1,10,8,8,253,27,258); INSERT INTO Ball_by_Ball VALUES (548370,3,5,1,5,10,1,6,85,299); INSERT INTO Ball_by_Ball VALUES (419114,6,2,1,2,1,1,9,8,83); INSERT INTO Ball_by_Ball VALUES (501253,17,6,1,4,10,7,148,236,235); INSERT INTO Ball_by_Ball VALUES (729312,5,6,1,4,1,4,305,41,9); INSERT INTO Ball_by_Ball VALUES (336022,15,6,1,1,6,4,4,129,136); INSERT INTO Match VALUES (335992,5,4,'2008-04-21 00:00:00',1,6,4,2,2,6,1,5,32); INSERT INTO Match VALUES (336002,1,7,'2008-04-29 00:00:00',1,5,1,2,2,7,1,7,44); INSERT INTO Match VALUES (336012,3,8,'2008-05-06 00:00:00',1,8,8,1,2,7,1,8,53); INSERT INTO Match VALUES (336015,1,2,'2008-05-08 00:00:00',1,5,1,2,1,5,1,1,1); INSERT INTO Match VALUES (336021,4,2,'2008-05-12 00:00:00',1,2,2,2,2,9,1,4,100); INSERT INTO Match VALUES (336022,1,6,'2008-05-13 00:00:00',1,5,1,2,1,23,1,1,144); INSERT INTO Match VALUES (336025,6,8,'2008-05-15 00:00:00',1,3,8,1,1,12,1,6,136); INSERT INTO Match VALUES (336034,3,2,'2008-05-21 00:00:00',1,8,2,2,1,14,1,2,124); INSERT INTO Match VALUES (336039,2,8,'2008-05-03 00:00:00',1,1,8,1,1,3,1,2,14); INSERT INTO Match VALUES (392187,2,5,'2009-04-18 00:00:00',2,10,2,2,1,75,1,2,6); INSERT INTO Match VALUES (392194,3,6,'2009-04-23 00:00:00',2,12,6,2,1,9,1,6,110); INSERT INTO Match VALUES (392204,2,1,'2009-04-29 00:00:00',2,12,1,2,2,5,1,2,11); INSERT INTO Match VALUES (392207,3,5,'2009-04-30 00:00:00',2,13,5,1,1,38,1,3,21); INSERT INTO Match VALUES (392218,2,5,'2009-05-07 00:00:00',2,13,5,1,2,7,1,5,196); INSERT INTO Match VALUES (392233,8,1,'2009-05-16 00:00:00',2,15,8,1,2,6,1,8,57); INSERT INTO Match VALUES (392235,6,5,'2009-05-17 00:00:00',2,17,6,2,1,14,1,6,110); INSERT INTO Match VALUES (392237,2,6,'2009-05-19 00:00:00',2,15,6,2,2,7,1,2,9); INSERT INTO Match VALUES (392243,2,3,'2009-05-23 00:00:00',2,15,2,1,2,6,1,2,96); INSERT INTO Match VALUES (419114,1,2,'2010-03-14 00:00:00',3,5,1,1,2,7,1,1,87); INSERT INTO Match VALUES (419137,7,4,'2010-03-30 00:00:00',3,18,7,1,2,4,1,7,194); INSERT INTO Match VALUES (419145,6,2,'2010-04-04 00:00:00',3,3,6,2,1,37,1,6,241); INSERT INTO Match VALUES (419148,5,4,'2010-04-07 00:00:00',3,6,4,2,2,9,1,5,224); INSERT INTO Match VALUES (419169,2,8,'2010-04-24 00:00:00',3,9,8,2,2,9,1,2,124); INSERT INTO Match VALUES (501214,5,1,'2011-04-15 00:00:00',4,6,1,1,2,9,1,1,40); INSERT INTO Match VALUES (501217,8,4,'2011-04-16 00:00:00',4,7,4,1,2,8,1,4,167); INSERT INTO Match VALUES (501224,1,9,'2011-04-20 00:00:00',4,5,1,1,1,6,1,9,64); INSERT INTO Match VALUES (501230,5,9,'2011-04-24 00:00:00',4,6,5,1,2,8,1,5,38); INSERT INTO Match VALUES (501240,5,10,'2011-05-01 00:00:00',4,6,5,1,2,6,1,5,52); INSERT INTO Match VALUES (501247,9,1,'2011-05-05 00:00:00',4,23,1,1,1,17,1,9,104); INSERT INTO Match VALUES (501253,4,10,'2011-05-08 00:00:00',4,2,4,2,2,5,1,10,235); INSERT INTO Match VALUES (501258,3,6,'2011-05-12 00:00:00',4,8,3,2,1,18,1,3,20); INSERT INTO Match VALUES (501264,10,8,'2011-05-16 00:00:00',4,9,8,1,2,6,1,8,136); INSERT INTO Match VALUES (548311,3,7,'2012-04-04 00:00:00',5,8,7,1,2,8,1,7,304); INSERT INTO Match VALUES (548325,1,5,'2012-04-13 00:00:00',5,5,5,2,2,5,1,1,276); INSERT INTO Match VALUES (548337,3,5,'2012-04-21 00:00:00',5,8,5,2,2,7,1,3,303); INSERT INTO Match VALUES (548370,5,10,'2012-05-13 00:00:00',5,6,5,2,1,45,1,5,335); INSERT INTO Match VALUES (548378,8,5,'2012-05-18 00:00:00',5,7,5,2,2,5,1,8,94); INSERT INTO Match VALUES (548385,6,3,'2012-05-25 00:00:00',5,8,6,1,1,86,1,3,185); INSERT INTO Match VALUES (598013,2,1,'2013-04-11 00:00:00',6,1,2,1,2,8,1,2,162); INSERT INTO Match VALUES (598017,3,2,'2013-04-13 00:00:00',6,8,3,1,2,4,1,3,35); INSERT INTO Match VALUES (598023,10,11,'2013-04-17 00:00:00',6,26,10,1,1,11,1,11,136); INSERT INTO Match VALUES (598024,5,7,'2013-04-17 00:00:00',6,6,5,2,1,87,1,5,85); INSERT INTO Match VALUES (598028,2,5,'2013-04-20 00:00:00',6,1,2,1,2,7,1,2,81); INSERT INTO Match VALUES (598032,2,10,'2013-04-23 00:00:00',6,1,10,1,1,130,1,2,162); INSERT INTO Match VALUES (598041,5,2,'2013-04-29 00:00:00',6,6,5,1,2,4,1,5,351); INSERT INTO Match VALUES (598042,7,4,'2013-04-29 00:00:00',6,4,7,2,1,4,1,7,57); INSERT INTO Match VALUES (598043,10,3,'2013-04-30 00:00:00',6,26,3,2,1,37,1,3,20); INSERT INTO Match VALUES (598056,11,3,'2013-05-08 00:00:00',6,7,11,1,1,77,1,3,21); INSERT INTO Match VALUES (598075,3,7,'2013-05-21 00:00:00',6,3,3,2,1,48,1,3,19); INSERT INTO Match VALUES (729284,7,1,'2014-04-16 00:00:00',7,29,1,2,1,41,1,1,9); INSERT INTO Match VALUES (729306,11,6,'2014-04-25 00:00:00',7,31,11,2,1,4,1,11,254); INSERT INTO Match VALUES (729312,1,4,'2014-04-26 00:00:00',7,29,1,1,1,23,1,4,367); INSERT INTO Match VALUES (729314,6,7,'2014-04-27 00:00:00',7,30,7,2,2,6,1,6,185); INSERT INTO Match VALUES (733988,7,2,'2014-05-06 00:00:00',7,4,2,1,1,19,1,7,57); INSERT INTO Match VALUES (733992,4,3,'2014-05-07 00:00:00',7,20,3,1,1,44,1,4,305); INSERT INTO Match VALUES (733996,2,4,'2014-05-09 00:00:00',7,1,2,1,1,32,1,4,367); INSERT INTO Match VALUES (734002,4,1,'2014-05-11 00:00:00',7,20,1,1,2,9,1,1,40); INSERT INTO Match VALUES (734012,11,4,'2014-05-14 00:00:00',7,7,4,1,2,6,1,4,62); INSERT INTO Match VALUES (734024,6,4,'2014-05-19 00:00:00',7,3,4,1,2,4,1,4,374); INSERT INTO Match VALUES (734026,11,2,'2014-05-20 00:00:00',7,7,2,2,2,7,1,11,187); INSERT INTO Match VALUES (734030,4,7,'2014-05-21 00:00:00',7,2,7,1,2,7,1,7,383); INSERT INTO Match VALUES (734040,2,3,'2014-05-24 00:00:00',7,1,3,1,2,8,1,3,20); INSERT INTO Match VALUES (734044,4,6,'2014-05-25 00:00:00',7,2,4,1,2,7,1,4,345); INSERT INTO Match VALUES (829714,4,5,'2015-04-10 00:00:00',8,32,4,1,1,26,1,5,310); INSERT INTO Match VALUES (829730,4,6,'2015-04-15 00:00:00',8,32,4,2,2,5,1,6,260); INSERT INTO Match VALUES (829748,11,1,'2015-04-22 00:00:00',8,25,1,1,1,16,1,11,187); INSERT INTO Match VALUES (829754,5,2,'2015-04-24 00:00:00',8,19,2,1,2,9,1,2,378); INSERT INTO Match VALUES (829774,7,5,'2015-05-01 00:00:00',8,4,5,1,1,8,1,7,208); INSERT INTO Match VALUES (829782,5,6,'2015-05-03 00:00:00',8,18,6,1,1,14,1,5,85); INSERT INTO Match VALUES (829790,2,4,'2015-05-06 00:00:00',8,1,4,1,1,138,1,2,162); INSERT INTO Match VALUES (829816,5,1,'2015-05-16 00:00:00',8,18,5,2,1,9,1,5,32); INSERT INTO Match VALUES (980906,7,12,'2016-04-09 00:00:00',9,4,7,2,2,9,1,12,85); INSERT INTO Match VALUES (980910,4,13,'2016-04-11 00:00:00',9,33,13,1,2,5,1,13,254); INSERT INTO Match VALUES (980916,13,12,'2016-04-14 00:00:00',9,34,12,2,2,7,1,13,254); INSERT INTO Match VALUES (980952,7,1,'2016-04-28 00:00:00',9,4,7,1,2,6,1,7,57); INSERT INTO Match VALUES (980988,11,6,'2016-05-12 00:00:00',9,7,6,1,2,7,1,6,350); INSERT INTO Match VALUES (980992,2,13,'2016-05-14 00:00:00',9,1,13,1,1,144,1,2,110); INSERT INTO Match VALUES (981000,1,2,'2016-05-16 00:00:00',9,5,2,1,2,9,1,2,8); INSERT INTO Match VALUES (981010,12,4,'2016-05-21 00:00:00',9,25,4,2,2,4,1,12,20); INSERT INTO Match VALUES (981018,13,2,'2016-05-24 00:00:00',9,1,2,1,2,4,1,2,110); INSERT INTO Outcome VALUES (1,'Result'); INSERT INTO Outcome VALUES (2,'No Result'); INSERT INTO Outcome VALUES (3,'Superover'); INSERT INTO Player VALUES (1,'SC Ganguly','1972-07-08 00:00:00',1,1,1); INSERT INTO Player VALUES (2,'BB McCullum','1981-09-27 00:00:00',2,1,4); INSERT INTO Player VALUES (3,'RT Ponting','1974-12-19 00:00:00',2,1,5); INSERT INTO Player VALUES (4,'DJ Hussey','1977-07-15 00:00:00',2,2,5); INSERT INTO Player VALUES (6,'R Dravid','1973-01-11 00:00:00',2,2,1); INSERT INTO Player VALUES (7,'W Jaffer','1978-02-16 00:00:00',2,2,1); INSERT INTO Player VALUES (8,'V Kohli','1988-11-05 00:00:00',2,1,1); INSERT INTO Player VALUES (9,'JH Kallis','1975-10-16 00:00:00',2,3,2); INSERT INTO Player VALUES (11,'MV Boucher','1976-12-03 00:00:00',2,1,2); INSERT INTO Player VALUES (14,'P Kumar','1986-10-02 00:00:00',2,1,1); INSERT INTO Player VALUES (15,'Z Khan','1978-10-07 00:00:00',2,6,1); INSERT INTO Player VALUES (17,'PA Patel','1985-03-09 00:00:00',1,NULL,1); INSERT INTO Player VALUES (18,'ML Hayden','1971-10-29 00:00:00',1,1,5); INSERT INTO Player VALUES (19,'MEK Hussey','1975-05-27 00:00:00',1,1,5); INSERT INTO Player VALUES (20,'MS Dhoni','1981-07-07 00:00:00',2,1,1); INSERT INTO Player VALUES (21,'SK Raina','1986-11-27 00:00:00',1,2,1); INSERT INTO Player VALUES (23,'S Badrinath','1980-08-30 00:00:00',2,2,1); INSERT INTO Player VALUES (26,'KC Sangakkara','1977-10-27 00:00:00',1,2,7); INSERT INTO Player VALUES (27,'Yuvraj Singh','1981-12-12 00:00:00',1,7,1); INSERT INTO Player VALUES (31,'YK Pathan','1982-11-17 00:00:00',2,2,1); INSERT INTO Player VALUES (32,'SR Watson','1981-06-17 00:00:00',2,3,5); INSERT INTO Player VALUES (35,'RA Jadeja','1988-12-06 00:00:00',1,7,1); INSERT INTO Player VALUES (38,'SK Warne','1969-09-13 00:00:00',2,4,5); INSERT INTO Player VALUES (39,'SK Trivedi','1982-09-04 00:00:00',2,1,1); INSERT INTO Player VALUES (40,'G Gambhir','1981-10-14 00:00:00',1,10,1); INSERT INTO Player VALUES (41,'V Sehwag','1978-10-20 00:00:00',2,2,1); INSERT INTO Player VALUES (42,'S Dhawan','1985-12-05 00:00:00',1,2,1); INSERT INTO Player VALUES (44,'ST Jayasuriya','1969-06-30 00:00:00',1,7,7); INSERT INTO Player VALUES (46,'RV Uthappa','1985-11-11 00:00:00',2,1,1); INSERT INTO Player VALUES (50,'Harbhajan Singh','1980-07-03 00:00:00',2,2,1); INSERT INTO Player VALUES (51,'S Chanderpaul','1974-08-16 00:00:00',1,10,8); INSERT INTO Player VALUES (52,'LRPL Taylor','1984-03-08 00:00:00',2,2,4); INSERT INTO Player VALUES (53,'AC Gilchrist','1971-11-14 00:00:00',1,2,5); INSERT INTO Player VALUES (55,'VVS Laxman','1974-11-01 00:00:00',2,2,1); INSERT INTO Player VALUES (56,'A Symonds','1975-06-09 00:00:00',2,2,5); INSERT INTO Player VALUES (57,'RG Sharma','1987-04-30 00:00:00',2,2,1); INSERT INTO Player VALUES (58,'SB Styris','1975-07-10 00:00:00',2,1,4); INSERT INTO Player VALUES (61,'RP Singh','1985-12-06 00:00:00',2,6,1); INSERT INTO Player VALUES (62,'WP Saha','1984-10-24 00:00:00',2,NULL,1); INSERT INTO Player VALUES (64,'DPMD Jayawardene','1977-05-27 00:00:00',2,1,7); INSERT INTO Player VALUES (66,'B Lee','1976-11-08 00:00:00',2,11,5); INSERT INTO Player VALUES (67,'PP Chawla','1988-12-24 00:00:00',1,10,1); INSERT INTO Player VALUES (69,'Kamran Akmal','1982-01-13 00:00:00',2,NULL,6); INSERT INTO Player VALUES (70,'Shahid Afridi','1980-03-01 00:00:00',2,4,6); INSERT INTO Player VALUES (71,'DJ Bravo','1983-10-07 00:00:00',2,5,8); INSERT INTO Player VALUES (77,'S Sreesanth','1983-02-06 00:00:00',2,3,1); INSERT INTO Player VALUES (81,'R Vinay Kumar','1984-02-12 00:00:00',2,1,1); INSERT INTO Player VALUES (83,'M Kartik','1976-09-11 00:00:00',1,7,1); INSERT INTO Player VALUES (84,'I Sharma','1988-09-02 00:00:00',2,3,1); INSERT INTO Player VALUES (85,'AM Rahane','1988-06-06 00:00:00',2,1,1); INSERT INTO Player VALUES (87,'MK Tiwary','1985-11-14 00:00:00',2,4,1); INSERT INTO Player VALUES (88,'KD Karthik','1985-06-01 00:00:00',2,NULL,1); INSERT INTO Player VALUES (89,'R Bhatia','1979-10-22 00:00:00',2,5,1); INSERT INTO Player VALUES (94,'DW Steyn','1983-06-27 00:00:00',2,11,2); INSERT INTO Player VALUES (96,'MK Pandey','1989-09-10 00:00:00',2,1,1); INSERT INTO Player VALUES (97,'HH Gibbs','1974-02-23 00:00:00',2,12,2); INSERT INTO Player VALUES (100,'SE Marsh','1983-07-09 00:00:00',1,7,5); INSERT INTO Player VALUES (102,'Sohail Tanvir','1984-12-12 00:00:00',1,9,6); INSERT INTO Player VALUES (104,'BJ Hodge','1974-12-29 00:00:00',2,2,5); INSERT INTO Player VALUES (106,'AB Dinda','1984-03-25 00:00:00',2,5,1); INSERT INTO Player VALUES (107,'SP Fleming','1973-04-01 00:00:00',1,NULL,4); INSERT INTO Player VALUES (110,'AB de Villiers','1984-02-17 00:00:00',2,1,2); INSERT INTO Player VALUES (119,'Joginder Sharma','1983-10-23 00:00:00',2,3,1); INSERT INTO Player VALUES (121,'M Muralitharan','1972-04-17 00:00:00',2,2,7); INSERT INTO Player VALUES (124,'A Kumble','1970-10-17 00:00:00',2,4,1); INSERT INTO Player VALUES (126,'MM Patel','1983-07-12 00:00:00',2,5,1); INSERT INTO Player VALUES (129,'T Taibu','1983-05-14 00:00:00',2,1,9); INSERT INTO Player VALUES (130,'J Arunkumar','1975-01-18 00:00:00',2,2,1); INSERT INTO Player VALUES (131,'PP Ojha','1986-09-05 00:00:00',1,7,1); INSERT INTO Player VALUES (133,'SR Tendulkar','1973-04-24 00:00:00',2,2,1); INSERT INTO Player VALUES (135,'TM Dilshan','1976-10-14 00:00:00',2,2,7); INSERT INTO Player VALUES (136,'A Mishra','1982-11-24 00:00:00',2,10,1); INSERT INTO Player VALUES (139,'LA Pomersbach','1984-09-28 00:00:00',1,2,5); INSERT INTO Player VALUES (140,'Iqbal Abdulla','1989-12-02 00:00:00',1,7,1); INSERT INTO Player VALUES (144,'Shoaib Akhtar','1975-08-13 00:00:00',2,11,6); INSERT INTO Player VALUES (147,'DR Smith','1983-04-12 00:00:00',2,1,8); INSERT INTO Player VALUES (148,'SD Chitnis','1987-05-06 00:00:00',2,2,1); INSERT INTO Player VALUES (149,'CRD Fernando','1979-07-19 00:00:00',2,3,7); INSERT INTO Player VALUES (151,'L Balaji','1981-09-27 00:00:00',2,5,1); INSERT INTO Player VALUES (154,'JP Duminy','1984-04-14 00:00:00',1,2,2); INSERT INTO Player VALUES (158,'KP Pietersen','1980-06-27 00:00:00',2,2,2); INSERT INTO Player VALUES (161,'RS Bopara','1985-05-04 00:00:00',2,1,10); INSERT INTO Player VALUES (162,'CH Gayle','1979-09-21 00:00:00',1,2,8); INSERT INTO Player VALUES (167,'PC Valthaty','1983-12-07 00:00:00',2,1,1); INSERT INTO Player VALUES (178,'TL Suman','1983-12-15 00:00:00',2,2,1); INSERT INTO Player VALUES (183,'NV Ojha','1983-07-20 00:00:00',2,NULL,1); INSERT INTO Player VALUES (185,'M Vijay','1984-04-01 00:00:00',2,2,1); INSERT INTO Player VALUES (186,'SB Jakati','1980-11-27 00:00:00',1,7,1); INSERT INTO Player VALUES (187,'DA Warner','1986-10-27 00:00:00',1,10,5); INSERT INTO Player VALUES (190,'M Morkel','1984-10-06 00:00:00',1,11,2); INSERT INTO Player VALUES (191,'AD Mathews','1987-06-02 00:00:00',2,3,7); INSERT INTO Player VALUES (192,'J Botha','1982-05-02 00:00:00',2,2,2); INSERT INTO Player VALUES (194,'SL Malinga','1983-08-28 00:00:00',2,11,7); INSERT INTO Player VALUES (196,'A Singh','1981-06-21 00:00:00',2,5,1); INSERT INTO Player VALUES (201,'R Ashwin','1986-09-17 00:00:00',2,2,1); INSERT INTO Player VALUES (207,'AP Tare','1987-11-07 00:00:00',2,NULL,1); INSERT INTO Player VALUES (208,'AT Rayudu','1985-09-23 00:00:00',2,2,1); INSERT INTO Player VALUES (210,'R McLaren','1983-02-09 00:00:00',1,5,2); INSERT INTO Player VALUES (214,'MS Bisla','1984-12-27 00:00:00',2,NULL,1); INSERT INTO Player VALUES (216,'EJG Morgan','1986-09-10 00:00:00',1,1,10); INSERT INTO Player VALUES (221,'KA Pollard','1987-05-12 00:00:00',2,5,8); INSERT INTO Player VALUES (223,'DP Nannes','1976-05-16 00:00:00',2,14,5); INSERT INTO Player VALUES (224,'MJ Lumb','1980-02-12 00:00:00',1,1,10); INSERT INTO Player VALUES (235,'R Sharma','1987-04-30 00:00:00',2,2,1); INSERT INTO Player VALUES (236,'Mandeep Singh','1991-12-18 00:00:00',2,1,1); INSERT INTO Player VALUES (241,'PD Collingwood','1976-05-26 00:00:00',2,1,10); INSERT INTO Player VALUES (253,'MR Marsh','1991-10-20 00:00:00',2,1,5); INSERT INTO Player VALUES (254,'AJ Finch','1986-11-17 00:00:00',2,7,5); INSERT INTO Player VALUES (255,'STR Binny','1984-06-03 00:00:00',2,1,1); INSERT INTO Player VALUES (256,'Harmeet Singh','1992-09-07 00:00:00',1,7,1); INSERT INTO Player VALUES (258,'DT Christian','1983-05-04 00:00:00',2,3,5); INSERT INTO Player VALUES (259,'RV Gomez','1985-10-16 00:00:00',2,1,1); INSERT INTO Player VALUES (260,'MA Agarwal','1991-02-16 00:00:00',2,NULL,1); INSERT INTO Player VALUES (266,'AL Menaria','1990-10-29 00:00:00',1,7,1); INSERT INTO Player VALUES (275,'JEC Franklin','1980-11-07 00:00:00',1,13,4); INSERT INTO Player VALUES (276,'Shakib Al Hasan','1987-03-24 00:00:00',1,7,11); INSERT INTO Player VALUES (292,'CA Ingram','1985-07-03 00:00:00',1,10,2); INSERT INTO Player VALUES (293,'S Nadeem','1989-08-12 00:00:00',2,7,1); INSERT INTO Player VALUES (296,'VR Aaron','1989-10-29 00:00:00',2,11,1); INSERT INTO Player VALUES (299,'B Kumar','1990-02-05 00:00:00',2,1,1); INSERT INTO Player VALUES (303,'F du Plessis','1984-07-13 00:00:00',2,10,2); INSERT INTO Player VALUES (304,'RE Levi','1988-01-14 00:00:00',2,1,2); INSERT INTO Player VALUES (305,'GJ Maxwell','1988-10-14 00:00:00',2,2,5); INSERT INTO Player VALUES (306,'SPD Smith','1989-06-02 00:00:00',2,4,1); INSERT INTO Player VALUES (309,'KK Cooper','1989-02-16 00:00:00',2,1,8); INSERT INTO Player VALUES (310,'JP Faulkner','1990-04-29 00:00:00',2,6,5); INSERT INTO Player VALUES (315,'SP Narine','1988-05-26 00:00:00',1,2,8); INSERT INTO Player VALUES (320,'DA Miller','1989-06-10 00:00:00',1,2,2); INSERT INTO Player VALUES (321,'Azhar Mahmood','1975-02-28 00:00:00',2,3,6); INSERT INTO Player VALUES (329,'Gurkeerat Singh','1990-06-29 00:00:00',2,2,1); INSERT INTO Player VALUES (331,'PA Reddy','1991-02-11 00:00:00',2,10,1); INSERT INTO Player VALUES (334,'AD Russell','1988-04-29 00:00:00',2,11,8); INSERT INTO Player VALUES (335,'A Chandila','1983-12-05 00:00:00',2,2,1); INSERT INTO Player VALUES (345,'M Vohra','1993-07-18 00:00:00',2,1,1); INSERT INTO Player VALUES (346,'JD Unadkat','1991-10-18 00:00:00',2,13,1); INSERT INTO Player VALUES (350,'CH Morris','1987-04-30 00:00:00',2,3,2); INSERT INTO Player VALUES (351,'SV Samson','1994-11-11 00:00:00',2,NULL,1); INSERT INTO Player VALUES (355,'Q de Kock','1992-12-17 00:00:00',1,NULL,2); INSERT INTO Player VALUES (357,'MG Johnson','1981-11-02 00:00:00',1,14,5); INSERT INTO Player VALUES (364,'MM Sharma','1988-09-18 00:00:00',2,1,1); INSERT INTO Player VALUES (367,'Sandeep Sharma','1993-05-18 00:00:00',2,1,1); INSERT INTO Player VALUES (372,'CJ Anderson','1990-12-13 00:00:00',1,9,4); INSERT INTO Player VALUES (374,'AR Patel','1994-01-20 00:00:00',1,7,1); INSERT INTO Player VALUES (377,'TG Southee','1988-12-11 00:00:00',2,5,4); INSERT INTO Player VALUES (378,'MA Starc','1990-01-30 00:00:00',1,14,5); INSERT INTO Player VALUES (382,'YS Chahal','1990-07-23 00:00:00',2,4,1); INSERT INTO Player VALUES (383,'LMP Simmons','1985-01-25 00:00:00',2,5,8); INSERT INTO Player VALUES (392,'Karanveer Singh','1987-11-08 00:00:00',2,4,1); INSERT INTO Player VALUES (395,'Anureet Singh','1988-03-02 00:00:00',2,1,1); INSERT INTO Player VALUES (409,'MP Stoinis','1989-08-16 00:00:00',2,1,5); INSERT INTO Player VALUES (420,'RR Pant','1997-10-04 00:00:00',1,NULL,1); INSERT INTO Player VALUES (430,'A Zampa','1992-03-31 00:00:00',2,4,5); INSERT INTO Player VALUES (456,'K Santokie','1984-12-20 00:00:00',1,13,8); INSERT INTO Player VALUES (460,'Mustafizur Rahman','1995-09-06 00:00:00',1,6,11); INSERT INTO Batting_Style VALUES (1,'Left-hand bat'); INSERT INTO Batting_Style VALUES (2,'Right-hand bat'); INSERT INTO Bowling_Style VALUES (1,'Right-arm medium'); INSERT INTO Bowling_Style VALUES (2,'Right-arm offbreak'); INSERT INTO Bowling_Style VALUES (3,'Right-arm fast-medium'); INSERT INTO Bowling_Style VALUES (4,'Legbreak googly'); INSERT INTO Bowling_Style VALUES (5,'Right-arm medium-fast'); INSERT INTO Bowling_Style VALUES (6,'Left-arm fast-medium'); INSERT INTO Bowling_Style VALUES (7,'Slow left-arm orthodox'); INSERT INTO Bowling_Style VALUES (8,'Slow left-arm chinaman'); INSERT INTO Bowling_Style VALUES (9,'Left-arm medium-fast'); INSERT INTO Bowling_Style VALUES (10,'Legbreak'); INSERT INTO Bowling_Style VALUES (11,'Right-arm fast'); INSERT INTO Bowling_Style VALUES (12,'Right-arm bowler'); INSERT INTO Bowling_Style VALUES (13,'Left-arm medium'); INSERT INTO Bowling_Style VALUES (14,'Left-arm fast'); INSERT INTO Country VALUES (1,'India'); INSERT INTO Country VALUES (2,'South Africa'); INSERT INTO Country VALUES (3,'U.A.E'); INSERT INTO Country VALUES (4,'New Zealand'); INSERT INTO Country VALUES (5,'Australia'); INSERT INTO Country VALUES (6,'Pakistan'); INSERT INTO Country VALUES (7,'Sri Lanka'); INSERT INTO Country VALUES (8,'West Indies'); INSERT INTO Country VALUES (9,'Zimbabwea'); INSERT INTO Country VALUES (10,'England'); INSERT INTO Country VALUES (11,'Bangladesh'); INSERT INTO Country VALUES (12,'Netherlands'); INSERT INTO Season VALUES (1,32,100,102,2008); INSERT INTO Season VALUES (2,53,18,61,2009); INSERT INTO Season VALUES (3,133,133,131,2010); INSERT INTO Season VALUES (4,162,162,194,2011); INSERT INTO Season VALUES (5,315,162,190,2012); INSERT INTO Season VALUES (6,32,19,71,2013); INSERT INTO Season VALUES (7,305,46,364,2014); INSERT INTO Season VALUES (8,334,187,71,2015); INSERT INTO Season VALUES (9,8,8,299,2016); INSERT INTO Team VALUES (1,'Kolkata Knight Riders'); INSERT INTO Team VALUES (2,'Royal Challengers Bangalore'); INSERT INTO Team VALUES (3,'Chennai Super Kings'); INSERT INTO Team VALUES (4,'Kings XI Punjab'); INSERT INTO Team VALUES (5,'Rajasthan Royals'); INSERT INTO Team VALUES (6,'Delhi Daredevils'); INSERT INTO Team VALUES (7,'Mumbai Indians'); INSERT INTO Team VALUES (8,'Deccan Chargers'); INSERT INTO Team VALUES (9,'Kochi Tuskers Kerala'); INSERT INTO Team VALUES (10,'Pune Warriors'); INSERT INTO Team VALUES (11,'Sunrisers Hyderabad'); INSERT INTO Team VALUES (12,'Rising Pune Supergiants'); INSERT INTO Team VALUES (13,'Gujarat Lions'); INSERT INTO Toss_Decision VALUES (1,'field'); INSERT INTO Toss_Decision VALUES (2,'bat'); INSERT INTO Venue VALUES (1,'M Chinnaswamy Stadium',1); INSERT INTO Venue VALUES (2,'Punjab Cricket Association Stadium, Mohali',2); INSERT INTO Venue VALUES (3,'Feroz Shah Kotla',3); INSERT INTO Venue VALUES (4,'Wankhede Stadium',4); INSERT INTO Venue VALUES (5,'Eden Gardens',5); INSERT INTO Venue VALUES (6,'Sawai Mansingh Stadium',6); INSERT INTO Venue VALUES (7,'Rajiv Gandhi International Stadium, Uppal',7); INSERT INTO Venue VALUES (8,'MA Chidambaram Stadium, Chepauk',8); INSERT INTO Venue VALUES (9,'Dr DY Patil Sports Academy',4); INSERT INTO Venue VALUES (10,'Newlands',9); INSERT INTO Venue VALUES (11,'St George''s Park',10); INSERT INTO Venue VALUES (12,'Kingsmead',11); INSERT INTO Venue VALUES (13,'SuperSport Park',12); INSERT INTO Venue VALUES (14,'Buffalo Park',13); INSERT INTO Venue VALUES (15,'New Wanderers Stadium',14); INSERT INTO Venue VALUES (16,'De Beers Diamond Oval',15); INSERT INTO Venue VALUES (17,'OUTsurance Oval',16); INSERT INTO Venue VALUES (18,'Brabourne Stadium',4); INSERT INTO Venue VALUES (19,'Sardar Patel Stadium, Motera',17); INSERT INTO Venue VALUES (20,'Barabati Stadium',18); INSERT INTO Venue VALUES (21,'Vidarbha Cricket Association Stadium, Jamtha',19); INSERT INTO Venue VALUES (22,'Himachal Pradesh Cricket Association Stadium',20); INSERT INTO Venue VALUES (23,'Nehru Stadium',21); INSERT INTO Venue VALUES (24,'Holkar Cricket Stadium',22); INSERT INTO Venue VALUES (25,'Dr. Y.S. Rajasekhara Reddy ACA-VDCA Cricket Stadium',23); INSERT INTO Venue VALUES (26,'Subrata Roy Sahara Stadium',24); INSERT INTO Venue VALUES (27,'Shaheed Veer Narayan Singh International Stadium',25); INSERT INTO Venue VALUES (28,'JSCA International Stadium Complex',26); INSERT INTO Venue VALUES (29,'Sheikh Zayed Stadium',27); INSERT INTO Venue VALUES (30,'Sharjah Cricket Stadium',27); INSERT INTO Venue VALUES (31,'Dubai International Cricket Stadium',27); INSERT INTO Venue VALUES (32,'Maharashtra Cricket Association Stadium',24); INSERT INTO Venue VALUES (33,'Punjab Cricket Association IS Bindra Stadium, Mohali',2); INSERT INTO Venue VALUES (34,'Saurashtra Cricket Association Stadium',28); INSERT INTO Venue VALUES (35,'Green Park',29); INSERT INTO City VALUES (1,'Bangalore',1); INSERT INTO City VALUES (2,'Chandigarh',1); INSERT INTO City VALUES (3,'Delhi',1); INSERT INTO City VALUES (4,'Mumbai',1); INSERT INTO City VALUES (5,'Kolkata',1); INSERT INTO City VALUES (6,'Jaipur',1); INSERT INTO City VALUES (7,'Hyderabad',1); INSERT INTO City VALUES (8,'Chennai',1); INSERT INTO City VALUES (9,'Cape Town',2); INSERT INTO City VALUES (10,'Port Elizabeth',2); INSERT INTO City VALUES (11,'Durban',2); INSERT INTO City VALUES (12,'Centurion',2); INSERT INTO City VALUES (13,'East London',2); INSERT INTO City VALUES (14,'Johannesburg',2); INSERT INTO City VALUES (15,'Kimberley',2); INSERT INTO City VALUES (16,'Bloemfontein',2); INSERT INTO City VALUES (17,'Ahmedabad',1); INSERT INTO City VALUES (18,'Cuttack',1); INSERT INTO City VALUES (19,'Nagpur',1); INSERT INTO City VALUES (20,'Dharamsala',1); INSERT INTO City VALUES (21,'Kochi',1); INSERT INTO City VALUES (22,'Indore',1); INSERT INTO City VALUES (23,'Visakhapatnam',1); INSERT INTO City VALUES (24,'Pune',1); INSERT INTO City VALUES (25,'Raipur',1); INSERT INTO City VALUES (26,'Ranchi',1); INSERT INTO City VALUES (27,'Abu Dhabi',3); INSERT INTO City VALUES (28,'Rajkot',1); INSERT INTO City VALUES (29,'Kanpur',1); INSERT INTO Win_By VALUES (1,'runs'); INSERT INTO Win_By VALUES (2,'wickets'); INSERT INTO Win_By VALUES (3,'NO Result'); INSERT INTO Win_By VALUES (4,'Tie'); INSERT INTO Extra_Type VALUES (1,'legbyes'); INSERT INTO Extra_Type VALUES (2,'wides'); INSERT INTO Extra_Type VALUES (3,'byes'); INSERT INTO Extra_Type VALUES (4,'noballs'); INSERT INTO Extra_Type VALUES (5,'penalty'); INSERT INTO Out_Type VALUES (1,'caught'); INSERT INTO Out_Type VALUES (2,'bowled'); INSERT INTO Out_Type VALUES (3,'run out'); INSERT INTO Out_Type VALUES (4,'lbw'); INSERT INTO Out_Type VALUES (5,'retired hurt'); INSERT INTO Out_Type VALUES (6,'stumped'); INSERT INTO Out_Type VALUES (7,'caught and bowled'); INSERT INTO Out_Type VALUES (8,'hit wicket'); INSERT INTO Out_Type VALUES (9,'obstructing the field'); INSERT INTO Role VALUES (1,'Captain'); INSERT INTO Role VALUES (2,'Keeper'); INSERT INTO Role VALUES (3,'Player'); INSERT INTO Role VALUES (4,'CaptainKeeper'); INSERT INTO Extra_Runs VALUES (336005,6,6,1,4,1); INSERT INTO Extra_Runs VALUES (980978,14,4,2,1,2); INSERT INTO Extra_Runs VALUES (829722,11,1,1,1,2); INSERT INTO Extra_Runs VALUES (729292,4,4,1,1,1); INSERT INTO Extra_Runs VALUES (829746,1,2,4,1,4); INSERT INTO Extra_Runs VALUES (392231,3,3,2,1,1); INSERT INTO Extra_Runs VALUES (598024,19,2,1,1,1); INSERT INTO Extra_Runs VALUES (729318,13,2,1,1,1); INSERT INTO Extra_Runs VALUES (419162,10,2,2,1,2); INSERT INTO Extra_Runs VALUES (598061,18,3,3,1,2); INSERT INTO Extra_Runs VALUES (981018,13,2,2,1,1); INSERT INTO Extra_Runs VALUES (419167,4,6,2,1,1); INSERT INTO Extra_Runs VALUES (980992,15,1,2,1,2); INSERT INTO Extra_Runs VALUES (548384,12,3,2,1,1); INSERT INTO Extra_Runs VALUES (419133,17,2,2,1,1); INSERT INTO Extra_Runs VALUES (392205,1,1,2,1,2); INSERT INTO Extra_Runs VALUES (335998,6,3,1,1,2); INSERT INTO Extra_Runs VALUES (729322,15,1,2,5,1); INSERT INTO Extra_Runs VALUES (981018,18,3,2,1,1); INSERT INTO Extra_Runs VALUES (392212,2,5,2,1,2); INSERT INTO Extra_Runs VALUES (548317,6,5,2,1,2); INSERT INTO Extra_Runs VALUES (598071,14,4,1,1,1); INSERT INTO Extra_Runs VALUES (501238,1,1,2,1,1); INSERT INTO Extra_Runs VALUES (980988,17,2,2,1,2); INSERT INTO Extra_Runs VALUES (548338,9,3,2,1,1); INSERT INTO Extra_Runs VALUES (419126,11,1,2,1,2); INSERT INTO Extra_Runs VALUES (419150,4,6,2,1,2); INSERT INTO Extra_Runs VALUES (548374,2,3,2,1,2); INSERT INTO Extra_Runs VALUES (419118,8,5,2,1,2); INSERT INTO Extra_Runs VALUES (598068,17,4,2,1,1); INSERT INTO Extra_Runs VALUES (419129,10,6,1,1,2); INSERT INTO Extra_Runs VALUES (419149,12,4,3,1,2); INSERT INTO Extra_Runs VALUES (336042,5,6,2,1,2); INSERT INTO Extra_Runs VALUES (501227,18,6,2,1,2); INSERT INTO Extra_Runs VALUES (829782,5,8,2,1,2); INSERT INTO Extra_Runs VALUES (598057,18,5,1,1,2); INSERT INTO Extra_Runs VALUES (392244,3,7,1,1,2); INSERT INTO Extra_Runs VALUES (829792,2,1,1,4,1); INSERT INTO Extra_Runs VALUES (829758,14,4,1,1,1); INSERT INTO Extra_Runs VALUES (734052,8,6,2,1,1); INSERT INTO Extra_Runs VALUES (980998,20,3,1,1,1); INSERT INTO Extra_Runs VALUES (392204,4,4,2,1,2); INSERT INTO Extra_Runs VALUES (598014,4,3,1,1,1); INSERT INTO Extra_Runs VALUES (336021,6,1,2,5,1); INSERT INTO Extra_Runs VALUES (392195,18,3,2,1,1); INSERT INTO Extra_Runs VALUES (392235,4,2,2,1,2); INSERT INTO Extra_Runs VALUES (419164,8,2,2,1,2); INSERT INTO Extra_Runs VALUES (501267,6,7,1,1,1); INSERT INTO Extra_Runs VALUES (598011,16,4,2,1,1); INSERT INTO Extra_Runs VALUES (336032,9,3,1,2,2); INSERT INTO Extra_Runs VALUES (598066,3,5,1,3,2); INSERT INTO Extra_Runs VALUES (980930,11,3,1,1,1); INSERT INTO Extra_Runs VALUES (419115,20,7,4,1,1); INSERT INTO Extra_Runs VALUES (392195,11,6,1,2,2); INSERT INTO Extra_Runs VALUES (980924,18,1,1,1,1); INSERT INTO Extra_Runs VALUES (336041,19,2,4,1,2); INSERT INTO Extra_Runs VALUES (548318,9,3,4,1,2); INSERT INTO Extra_Runs VALUES (829748,2,5,2,2,2); INSERT INTO Extra_Runs VALUES (336010,7,3,2,1,2); INSERT INTO Extra_Runs VALUES (829740,14,5,2,2,1); INSERT INTO Extra_Runs VALUES (598036,9,3,1,1,1); INSERT INTO Extra_Runs VALUES (501212,14,1,2,1,1); INSERT INTO Extra_Runs VALUES (980974,9,6,1,1,2); INSERT INTO Extra_Runs VALUES (829784,10,4,2,1,1); INSERT INTO Extra_Runs VALUES (980922,17,1,4,1,1); INSERT INTO Extra_Runs VALUES (598011,4,1,1,1,1); INSERT INTO Extra_Runs VALUES (598028,3,4,2,1,2); INSERT INTO Extra_Runs VALUES (598043,17,1,1,1,1); INSERT INTO Extra_Runs VALUES (829814,9,2,2,1,1); INSERT INTO Extra_Runs VALUES (392207,7,3,1,1,2); INSERT INTO Extra_Runs VALUES (336029,17,4,4,1,2); INSERT INTO Extra_Runs VALUES (598020,12,3,1,1,1); INSERT INTO Extra_Runs VALUES (829776,10,6,1,1,1); INSERT INTO Extra_Runs VALUES (733976,16,7,1,1,1); INSERT INTO Extra_Runs VALUES (598070,12,2,1,2,1); INSERT INTO Extra_Runs VALUES (501231,2,6,1,1,2); INSERT INTO Extra_Runs VALUES (829782,11,2,2,1,2); INSERT INTO Extra_Runs VALUES (598037,4,2,1,1,2); INSERT INTO Extra_Runs VALUES (980910,15,7,2,1,1); INSERT INTO Extra_Runs VALUES (501208,16,3,2,1,1); INSERT INTO Batsman_Scored VALUES (501233,11,6,0,2); INSERT INTO Batsman_Scored VALUES (598039,18,2,2,1); INSERT INTO Batsman_Scored VALUES (419131,17,3,1,1); INSERT INTO Batsman_Scored VALUES (548340,16,3,0,2); INSERT INTO Batsman_Scored VALUES (598037,18,4,4,2); INSERT INTO Batsman_Scored VALUES (419133,3,4,1,1); INSERT INTO Batsman_Scored VALUES (733990,18,2,0,2); INSERT INTO Batsman_Scored VALUES (501245,4,3,0,1); INSERT INTO Batsman_Scored VALUES (392205,6,5,0,2); INSERT INTO Batsman_Scored VALUES (734054,9,4,1,1); INSERT INTO Batsman_Scored VALUES (829800,9,1,0,1); INSERT INTO Batsman_Scored VALUES (419146,10,6,1,1); INSERT INTO Batsman_Scored VALUES (501236,2,7,0,1); INSERT INTO Batsman_Scored VALUES (734018,17,1,1,1); INSERT INTO Batsman_Scored VALUES (392215,14,2,4,1); INSERT INTO Batsman_Scored VALUES (598032,5,1,6,1); INSERT INTO Batsman_Scored VALUES (501241,11,4,1,2); INSERT INTO Batsman_Scored VALUES (392241,10,3,1,2); INSERT INTO Batsman_Scored VALUES (419159,1,2,1,1); INSERT INTO Batsman_Scored VALUES (548311,4,5,0,1); INSERT INTO Batsman_Scored VALUES (829778,6,2,0,2); INSERT INTO Batsman_Scored VALUES (548322,16,3,1,1); INSERT INTO Batsman_Scored VALUES (501263,7,1,1,1); INSERT INTO Batsman_Scored VALUES (392235,18,5,0,2); INSERT INTO Batsman_Scored VALUES (392232,3,5,0,1); INSERT INTO Batsman_Scored VALUES (734036,11,5,2,2); INSERT INTO Batsman_Scored VALUES (734048,15,3,1,2); INSERT INTO Batsman_Scored VALUES (548360,2,2,2,2); INSERT INTO Batsman_Scored VALUES (419129,20,5,1,1); INSERT INTO Batsman_Scored VALUES (598054,1,2,4,1); INSERT INTO Batsman_Scored VALUES (598058,2,2,1,1); INSERT INTO Batsman_Scored VALUES (548323,20,4,0,1); INSERT INTO Batsman_Scored VALUES (548348,11,2,0,2); INSERT INTO Batsman_Scored VALUES (501210,10,3,4,2); INSERT INTO Batsman_Scored VALUES (336032,15,6,6,1); INSERT INTO Batsman_Scored VALUES (336024,20,7,0,1); INSERT INTO Batsman_Scored VALUES (729302,11,2,1,1); INSERT INTO Batsman_Scored VALUES (598021,3,5,0,2); INSERT INTO Batsman_Scored VALUES (980956,17,1,6,1); INSERT INTO Batsman_Scored VALUES (419134,4,6,0,1); INSERT INTO Batsman_Scored VALUES (729308,3,5,0,2); INSERT INTO Batsman_Scored VALUES (829782,20,1,2,1); INSERT INTO Batsman_Scored VALUES (501221,3,4,4,1); INSERT INTO Batsman_Scored VALUES (980964,7,5,0,1); INSERT INTO Batsman_Scored VALUES (598005,17,5,0,2); INSERT INTO Batsman_Scored VALUES (734000,17,6,2,1); INSERT INTO Batsman_Scored VALUES (419118,1,2,0,1); INSERT INTO Batsman_Scored VALUES (734038,11,3,1,1); INSERT INTO Batsman_Scored VALUES (419146,9,3,2,2); INSERT INTO Batsman_Scored VALUES (392232,15,2,0,2); INSERT INTO Batsman_Scored VALUES (548324,14,1,1,2); INSERT INTO Batsman_Scored VALUES (729314,15,5,3,1); INSERT INTO Batsman_Scored VALUES (729286,15,4,0,1); INSERT INTO Batsman_Scored VALUES (336033,19,1,1,1); INSERT INTO Batsman_Scored VALUES (419152,10,4,0,2); INSERT INTO Batsman_Scored VALUES (501244,15,2,1,1); INSERT INTO Batsman_Scored VALUES (980964,15,2,0,2); INSERT INTO Batsman_Scored VALUES (392209,9,3,0,2); INSERT INTO Batsman_Scored VALUES (829770,15,3,2,1); INSERT INTO Batsman_Scored VALUES (548339,12,3,1,2); INSERT INTO Batsman_Scored VALUES (336021,10,6,1,1); INSERT INTO Batsman_Scored VALUES (598008,12,4,1,1); INSERT INTO Batsman_Scored VALUES (392234,8,7,0,2); INSERT INTO Batsman_Scored VALUES (548373,18,5,4,1); INSERT INTO Batsman_Scored VALUES (336041,8,4,0,2); INSERT INTO Batsman_Scored VALUES (419155,2,2,1,1); INSERT INTO Batsman_Scored VALUES (980954,8,1,0,1); INSERT INTO Batsman_Scored VALUES (829820,13,4,0,1); INSERT INTO Batsman_Scored VALUES (392209,1,3,1,2); INSERT INTO Batsman_Scored VALUES (729306,8,3,4,2); INSERT INTO Batsman_Scored VALUES (501259,3,5,4,1); INSERT INTO Batsman_Scored VALUES (501231,14,5,1,1); INSERT INTO Batsman_Scored VALUES (729306,8,4,1,2); INSERT INTO Batsman_Scored VALUES (729308,13,3,1,2); INSERT INTO Batsman_Scored VALUES (548322,3,4,4,1); INSERT INTO Batsman_Scored VALUES (548334,6,4,0,1); INSERT INTO Batsman_Scored VALUES (419170,9,4,1,2); INSERT INTO Batsman_Scored VALUES (336012,6,6,2,2); INSERT INTO Batsman_Scored VALUES (548348,14,6,6,2); INSERT INTO Batsman_Scored VALUES (392236,6,1,0,2); INSERT INTO Wicket_Taken VALUES (548379,5,3,167,1,29,1); INSERT INTO Wicket_Taken VALUES (501211,14,6,264,1,186,2); INSERT INTO Wicket_Taken VALUES (598036,19,6,321,3,9,1); INSERT INTO Wicket_Taken VALUES (501204,13,6,154,1,192,1); INSERT INTO Wicket_Taken VALUES (981010,18,3,329,1,465,1); INSERT INTO Wicket_Taken VALUES (548378,9,4,255,2,NULL,1); INSERT INTO Wicket_Taken VALUES (598022,19,3,283,1,187,2); INSERT INTO Wicket_Taken VALUES (829816,7,7,85,3,276,1); INSERT INTO Wicket_Taken VALUES (598046,2,6,139,2,NULL,2); INSERT INTO Wicket_Taken VALUES (336005,19,3,105,3,35,2); INSERT INTO Wicket_Taken VALUES (981008,19,2,408,1,429,2); INSERT INTO Wicket_Taken VALUES (829796,20,4,67,1,62,2); INSERT INTO Wicket_Taken VALUES (980990,11,4,431,1,62,1); INSERT INTO Wicket_Taken VALUES (598059,20,6,8,3,353,1); INSERT INTO Wicket_Taken VALUES (548366,12,2,71,1,255,2); INSERT INTO Wicket_Taken VALUES (548365,2,6,57,4,NULL,1); INSERT INTO Wicket_Taken VALUES (501252,18,2,259,1,8,1); INSERT INTO Wicket_Taken VALUES (548317,2,6,40,1,132,2); INSERT INTO Wicket_Taken VALUES (335991,13,8,1,2,NULL,2); INSERT INTO Wicket_Taken VALUES (829736,17,6,216,2,NULL,2); INSERT INTO Wicket_Taken VALUES (733996,17,3,320,1,382,1); INSERT INTO Wicket_Taken VALUES (419111,5,6,203,1,131,1); INSERT INTO Wicket_Taken VALUES (501272,2,1,178,1,31,2); INSERT INTO Wicket_Taken VALUES (548360,18,6,57,2,NULL,2); INSERT INTO Wicket_Taken VALUES (548363,14,4,266,1,171,2); INSERT INTO Wicket_Taken VALUES (598055,14,6,95,7,NULL,2); INSERT INTO Wicket_Taken VALUES (548377,9,1,64,1,110,2); INSERT INTO Wicket_Taken VALUES (548324,13,1,46,1,228,1); INSERT INTO Wicket_Taken VALUES (336039,14,2,8,1,59,1); INSERT INTO Wicket_Taken VALUES (419128,12,4,21,1,9,2); INSERT INTO Wicket_Taken VALUES (501251,20,6,293,1,126,2); INSERT INTO Wicket_Taken VALUES (419137,19,6,243,2,NULL,1); INSERT INTO Wicket_Taken VALUES (829778,20,4,340,1,NULL,1); INSERT INTO Wicket_Taken VALUES (734006,10,5,354,3,57,1); INSERT INTO Wicket_Taken VALUES (501219,7,5,229,3,140,1); INSERT INTO Wicket_Taken VALUES (548326,4,2,41,1,258,2); INSERT INTO Wicket_Taken VALUES (980950,12,6,21,1,339,1); INSERT INTO Wicket_Taken VALUES (548347,19,1,52,4,NULL,1); INSERT INTO Wicket_Taken VALUES (419161,7,4,231,4,NULL,2); INSERT INTO Wicket_Taken VALUES (733976,15,3,2,1,31,1); INSERT INTO Wicket_Taken VALUES (980978,4,6,407,1,183,2); INSERT INTO Wicket_Taken VALUES (548327,13,4,307,2,NULL,2); INSERT INTO Wicket_Taken VALUES (829716,19,6,166,1,21,2); INSERT INTO Wicket_Taken VALUES (392237,11,3,110,2,NULL,1); INSERT INTO Wicket_Taken VALUES (829756,19,1,340,1,17,2); INSERT INTO Wicket_Taken VALUES (980954,20,4,21,2,NULL,2); INSERT INTO Wicket_Taken VALUES (501237,17,5,27,1,283,2); INSERT INTO Wicket_Taken VALUES (598060,19,2,57,1,106,2); INSERT INTO Wicket_Taken VALUES (829714,11,2,306,1,392,1); INSERT INTO Wicket_Taken VALUES (336045,20,1,127,1,101,1); INSERT INTO Wicket_Taken VALUES (419134,13,4,31,1,21,1); INSERT INTO Wicket_Taken VALUES (981024,7,4,42,1,434,1); INSERT INTO Wicket_Taken VALUES (392214,9,6,147,4,NULL,2); INSERT INTO Wicket_Taken VALUES (734022,5,2,32,1,208,2); INSERT INTO Wicket_Taken VALUES (548375,9,3,40,2,NULL,1); INSERT INTO Wicket_Taken VALUES (501235,12,5,40,1,54,1); INSERT INTO Wicket_Taken VALUES (829828,16,6,20,2,NULL,2); INSERT INTO Wicket_Taken VALUES (829758,6,1,100,4,NULL,2); INSERT INTO Wicket_Taken VALUES (598028,7,4,135,1,277,2); INSERT INTO Wicket_Taken VALUES (392211,4,2,110,2,NULL,2); INSERT INTO Wicket_Taken VALUES (335996,14,5,76,1,50,1); INSERT INTO Wicket_Taken VALUES (548327,20,2,35,1,306,1); INSERT INTO Wicket_Taken VALUES (829732,11,2,351,1,183,2); INSERT INTO Wicket_Taken VALUES (548331,12,6,266,1,154,2); INSERT INTO Wicket_Taken VALUES (548364,11,1,313,1,333,2); INSERT INTO Wicket_Taken VALUES (981020,16,5,394,3,462,1); INSERT INTO Wicket_Taken VALUES (548377,3,2,135,1,29,1); INSERT INTO Wicket_Taken VALUES (501251,20,5,190,1,56,2); INSERT INTO Wicket_Taken VALUES (336039,20,6,6,1,NULL,1); INSERT INTO Wicket_Taken VALUES (733982,20,1,378,3,254,2); INSERT INTO Wicket_Taken VALUES (598022,18,6,239,3,29,2); INSERT INTO Wicket_Taken VALUES (598023,5,2,46,1,327,2); INSERT INTO Wicket_Taken VALUES (980958,6,2,8,1,325,2); INSERT INTO Wicket_Taken VALUES (419158,20,4,191,1,18,1); INSERT INTO Wicket_Taken VALUES (734026,6,1,162,1,366,1); INSERT INTO Wicket_Taken VALUES (501229,6,1,263,1,131,1); INSERT INTO Wicket_Taken VALUES (336021,15,6,6,2,NULL,1); INSERT INTO Wicket_Taken VALUES (419159,2,3,9,2,NULL,2); INSERT INTO Wicket_Taken VALUES (335993,19,4,57,1,118,1); INSERT INTO Wicket_Taken VALUES (419149,11,2,162,2,NULL,1); INSERT INTO Umpire VALUES (1,'Asad Rauf',6); INSERT INTO Umpire VALUES (2,'MR Benson',10); INSERT INTO Umpire VALUES (3,'Aleem Dar',6); INSERT INTO Umpire VALUES (4,'SJ Davis',10); INSERT INTO Umpire VALUES (5,'BF Bowden',4); INSERT INTO Umpire VALUES (6,'IL Howell',2); INSERT INTO Umpire VALUES (7,'DJ Harper',5); INSERT INTO Umpire VALUES (8,'RE Koertzen',2); INSERT INTO Umpire VALUES (9,'BR Doctrove',8); INSERT INTO Umpire VALUES (10,'AV Jayaprakash',1); INSERT INTO Umpire VALUES (11,'BG Jerling',2); INSERT INTO Umpire VALUES (12,'M Erasmus',2); INSERT INTO Umpire VALUES (13,'HDPK Dharmasena',7); INSERT INTO Umpire VALUES (14,'S Asnani',1); INSERT INTO Umpire VALUES (15,'GAV Baxter',4); INSERT INTO Umpire VALUES (16,'SS Hazare',1); INSERT INTO Umpire VALUES (17,'K Hariharan',1); INSERT INTO Umpire VALUES (18,'SL Shastri',1); INSERT INTO Umpire VALUES (19,'SK Tarapore',1); INSERT INTO Umpire VALUES (20,'S Ravi',1); INSERT INTO Umpire VALUES (21,'SJA Taufel',5); INSERT INTO Umpire VALUES (22,'S Das',1); INSERT INTO Umpire VALUES (23,'AM Saheba',1); INSERT INTO Umpire VALUES (24,'PR Reiffel',5); INSERT INTO Umpire VALUES (25,'JD Cloete',2); INSERT INTO Umpire VALUES (26,'AK Chaudhary',1); INSERT INTO Umpire VALUES (27,'VA Kulkarni',1); INSERT INTO Umpire VALUES (28,'BNJ Oxenford',5); INSERT INTO Umpire VALUES (29,'CK Nandan',1); INSERT INTO Umpire VALUES (30,'C Shamshuddin',1); INSERT INTO Umpire VALUES (31,'NJ Llong',10); INSERT INTO Umpire VALUES (32,'RK Illingworth',10); INSERT INTO Umpire VALUES (33,'RM Deshpande',1); INSERT INTO Umpire VALUES (34,'K Srinath',1); INSERT INTO Umpire VALUES (35,'SD Fry',5); INSERT INTO Umpire VALUES (36,'CB Gaffaney',4); INSERT INTO Umpire VALUES (37,'PG Pathak',1); INSERT INTO Umpire VALUES (38,'Nitin Menon',1); INSERT INTO Umpire VALUES (39,'K Bharatan',1); INSERT INTO Umpire VALUES (40,'AY Dandekar',1); INSERT INTO Umpire VALUES (41,'KN Ananthapadmanabhan',1); INSERT INTO Umpire VALUES (42,'A Nand Kishore',1); INSERT INTO Umpire VALUES (43,'GA Pratapkumar',1); INSERT INTO Umpire VALUES (44,'RB Tiffin',9); INSERT INTO Umpire VALUES (45,'I Shivram',1); INSERT INTO Umpire VALUES (46,'SD Ranade',1); INSERT INTO Umpire VALUES (47,'TH Wijewardene',7); INSERT INTO Umpire VALUES (48,'AL Hill',4); INSERT INTO Umpire VALUES (49,'RJ Tucker',5); INSERT INTO Umpire VALUES (50,'Subroto Das',1); INSERT INTO Umpire VALUES (51,'K Srinivasan',1); INSERT INTO Umpire VALUES (52,'VK Sharma',1); INSERT INTO Player_Match VALUES (980918,185,3,4); INSERT INTO Player_Match VALUES (501254,248,3,3); INSERT INTO Player_Match VALUES (548364,10,3,8); INSERT INTO Player_Match VALUES (729292,109,3,2); INSERT INTO Player_Match VALUES (734038,356,3,4); INSERT INTO Player_Match VALUES (419126,26,4,4); INSERT INTO Player_Match VALUES (392193,124,3,2); INSERT INTO Player_Match VALUES (829740,32,1,5); INSERT INTO Player_Match VALUES (501262,439,3,6); INSERT INTO Player_Match VALUES (392215,138,3,5); INSERT INTO Player_Match VALUES (419125,88,4,6); INSERT INTO Player_Match VALUES (598016,357,3,7); INSERT INTO Player_Match VALUES (980998,15,1,6); INSERT INTO Player_Match VALUES (733980,158,1,6); INSERT INTO Player_Match VALUES (501238,183,2,6); INSERT INTO Player_Match VALUES (548335,306,3,10); INSERT INTO Player_Match VALUES (829758,100,3,4); INSERT INTO Player_Match VALUES (336003,86,3,6); INSERT INTO Player_Match VALUES (548344,323,3,7); INSERT INTO Player_Match VALUES (548386,23,3,3); INSERT INTO Player_Match VALUES (501236,32,3,5); INSERT INTO Player_Match VALUES (419118,204,3,1); INSERT INTO Player_Match VALUES (829800,236,3,2); INSERT INTO Player_Match VALUES (501269,446,3,8); INSERT INTO Player_Match VALUES (548320,284,3,1); INSERT INTO Player_Match VALUES (981022,385,3,11); INSERT INTO Player_Match VALUES (335989,118,3,6); INSERT INTO Player_Match VALUES (598035,21,3,3); INSERT INTO Player_Match VALUES (548386,185,3,3); INSERT INTO Player_Match VALUES (501218,235,3,10); INSERT INTO Player_Match VALUES (829750,110,3,2); INSERT INTO Player_Match VALUES (733996,367,3,4); INSERT INTO Player_Match VALUES (392203,136,3,6); INSERT INTO Player_Match VALUES (829710,81,3,7); INSERT INTO Player_Match VALUES (501231,281,3,10); INSERT INTO Player_Match VALUES (598005,94,3,11); INSERT INTO Player_Match VALUES (733988,162,3,2); INSERT INTO Player_Match VALUES (734006,194,3,7); INSERT INTO Player_Match VALUES (336004,99,3,8); INSERT INTO Player_Match VALUES (548360,50,1,7); INSERT INTO Player_Match VALUES (548346,1,1,10); INSERT INTO Player_Match VALUES (734052,305,3,4); INSERT INTO Player_Match VALUES (829756,14,3,11); INSERT INTO Player_Match VALUES (548373,71,3,3); INSERT INTO Player_Match VALUES (980932,221,3,7); INSERT INTO Player_Match VALUES (392232,20,4,3); INSERT INTO Player_Match VALUES (980940,207,3,11); INSERT INTO Player_Match VALUES (980972,183,2,11); INSERT INTO Player_Match VALUES (980966,410,3,13); INSERT INTO Player_Match VALUES (598068,88,2,7); INSERT INTO Player_Match VALUES (548329,204,3,5); INSERT INTO Player_Match VALUES (336045,39,3,5); INSERT INTO Player_Match VALUES (729306,293,3,6); INSERT INTO Player_Match VALUES (419142,32,3,5); INSERT INTO Player_Match VALUES (980960,62,2,4); INSERT INTO Player_Match VALUES (734012,41,3,4); INSERT INTO Player_Match VALUES (548326,52,3,6); INSERT INTO Player_Match VALUES (548317,95,3,1); INSERT INTO Player_Match VALUES (598041,61,3,2); INSERT INTO Player_Match VALUES (501236,255,3,5); INSERT INTO Player_Match VALUES (829766,393,3,6); INSERT INTO Player_Match VALUES (392215,183,2,5); INSERT INTO Player_Match VALUES (734036,386,3,6); INSERT INTO Player_Match VALUES (980996,427,3,4); INSERT INTO Player_Match VALUES (501210,208,3,7); INSERT INTO Player_Match VALUES (336016,53,4,8); INSERT INTO Player_Match VALUES (829726,377,3,5); INSERT INTO Player_Match VALUES (336015,104,3,1); INSERT INTO Player_Match VALUES (548375,221,3,7); INSERT INTO Player_Match VALUES (598050,100,3,4); INSERT INTO Player_Match VALUES (598028,277,2,5); INSERT INTO Player_Match VALUES (548373,125,3,3); INSERT INTO Player_Match VALUES (419132,67,3,4); INSERT INTO Player_Match VALUES (419147,194,3,7); INSERT INTO Player_Match VALUES (392221,178,3,8); INSERT INTO Player_Match VALUES (335997,6,1,2); INSERT INTO Player_Match VALUES (501216,125,3,3); INSERT INTO Player_Match VALUES (501257,52,3,5); INSERT INTO Player_Match VALUES (598056,94,3,11); INSERT INTO Player_Match VALUES (501228,25,3,6);