DATA INSERTION.sql

--Data Insertion statements: 

INSERT INTO Players VALUES
('00001','Hardik Pandya','India','1993-10-11','All-rounder',146.33,'right-arm fast-medium','right-handed'),
('00002','Rashid Khan','Afghanistan','1998-09-20','All-rounder',154.29,'light-arm legbreak','right-handed'),
('00003','David Miller','South Africa','1988-06-10','Batsman',137.89,'right-arm offbreak','left-handed'),
('00004','Vijay Shankar','India','1991-01-26','All-rounder',127.44,'right-arm medium','right-handed'),
('00005','Shubman Gill','India','1999-09-08','Batsman',126.67,'right-arm offbreak','right-handed'),
('00006','Rahul Tewatia','India','1993-05-20','All-rounder',130.19,'right-arm legbreak','left-handed'),
('00007','Wridddhiman Saha','India','1984-10-24','Wicketkeeper',128.42,NULL,'right-handed'),
('00008','Mohammad Shami','India','1990-09-03','Bowler',94.52,'right-arm fast-medium','right-handed'),
('00009','Mohit Sharma','India','1988-09-18','Bowler',104.27,'right-arm fast-medium','right-handed'),
('00010','Alzarri Joseph','Jamaica','1996-11-20','Bowler',100,'right-arm fast-medium','right-handed'),
('00011','Kane Williamson','New Zealand','1990-08-08','Batsman',113.19,'right-arm offbreak','right-handed'),
('00012','M S Dhoni','India','1981-07-07','Wicketkeeper',135.77,'right-arm medium','right-handed'),
('00013','Ravindra Jadeja','India','1988-12-06','Bowler',127.62,'left-arm orthodox','left-handed'),
('00014','Suresh Raina','India','1986-11-27','Batsman',136.73,'right-arm offbreak','left-handed'),
('00015','Cheteshwar Pujara','India','1988-01-23','Batsman',99.74,'right-arm legbreak','right-handed'),
('00016','Deepak Chahar','India','1992-07-07','Bowler',138.6,'right-arm medium','right-handed'),
('00017','Mitchell Santner','New Zealand','1992-02-05','All-rounder',103.7,'left-arm orthodox','left-handed'),
('00018','Dwayne Bravo','Jamaica','1983-10-07','Batsman',129.57,'right-arm fast-medium','right-handed'),
('00019','Shardul Thakur','India','1991-12-16','Bowler',148.11,'right-arm fast-medium','right-handed'),
('00020','Imran Tahir','South Africa','1979-03-27','Bowler',89.19,'right-arm legbreak','right-handed'),
('00021','Moeen Ali','England','1987-06-18','Batsman',143.61,'right-arm offbreak','left-handed'),
('00022','Faf Du Plesis','South Africa','1984-07-13','Batsman',132.87,'right-arm legbreak','right-handed'),
('00023','Virat Kohli','India','1988-11-05','Batsman',129.67,'right-arm medium','right-handed'),
('00024','Rajat Patidar','India','1993-06-01','Batsman',144.29,'right-arm offbreak','right-handed'),
('00025','Devdutt Padikal','India','2000-07-07','Batsman',123.01,'right-arm offbreak','left-handed'),
('00026','Glenn Maxwell','Australia','1988-10-14','All-rounder',150.98,'right-arm offbreak','right-handed'),
('00027','Tim David','Singapore','1996-03-16','All-rounder',179.74,'right-arm medium','right-handed'),
('00028','Shahbaz Ahmed','India','1994-12-11','All-rounder',119.08,'left-arm orthodox','left-handed'),
('00029','AB de Villiers','South Africa','1984-02-17','Wicketkeeper',151.69,'right-arm medium','right-handed'),
('00030','Mohammed Siraj','India','1994-03-13','Bowler',88.07,'right-arm fast-medium','right-handed'),
('00031','Navdeep Saini','India','1992-11-23','Bowler',88.19,'right-arm fast','right-handed'),
('00032','Yuzvendra Chahal','India','1990-07-23','Bowler',43.02,'right-arm legbreak','right-handed'),
('00033','Srikar Bharat','India','1993-10-03','Batsman',122.07,NULL,'right-handed'),
('00034','Rohit Sharma','India','1987-04-30','Batsman',130.07,'right-arm offbreak','right-handed'),
('00035','Suryakumar Yadav','India','1990-09-14','Batsman',136.87,'right-arm offbreak','right-handed'),
('00036','Chris Lynn','Australia','1990-04-10','Batsman',140.63,'left-arm orthodox','right-handed'),
('00037','Krunal Pandya','India','1991-03-24','All-rounder',135.71,'left-arm orthodox','left-handed'),
('00038','Kieron Pollard','Jamaica','1987-05-12','All-rounder',147.32,'right-arm medium','right-handed'),
('00039','James Neesham','New Zealand','1990-09-17','All-rounder',98.92,'right-arm medium','left-handed'),
('00040','Quinton de Kock','South Africa','1992-12-17','Wicketkeeper',133.91,NULL,'left-handed'),
('00041','Ishan Kishan','India','1998-07-18','Wicketkeeper',133.36,NULL,'left-handed'),
('00042','Jasprit Bumrah','India','1993-12-06','Bowler',84.85,'right-arm fast','right-handed'),
('00043','Nathan Coulter-Nile','Australia','1987-10-11','Bowler',113.89,'right-arm fast','right-handed'),
('00044','Rahul Chahar','India','1999-08-04','Bowler',100,'right-arm legbreak','right-handed'),
('00045','Eoin Morgan','England','1986-09-10','Batsman',122.6,'right-arm medium','left-handed'),
('00046','Andre Russell','Jamaica','1988-04-29','All-rounder',177.09,'right-arm fast','right-handed'),
('00047','Venkatesh Iyer','India','1994-12-25','All-rounder',132.32,'right-arm medium','left-handed'),
('00048','Shakib Al Hasan','Bangladesh','1987-03-24','Batsman',124.49,'left-arm orthodox','left-handed'),
('00049','Dinesh Karthik','India','1985-06-01','Wicketkeeper',132.71,NULL,'right-handed'),
('00050','Sheldon Jackson','India','1986-09-27','Batsman',NULL,NULL,'right-handed'),
('00051','Harbhajan Singh','India','1980-07-03','Bowler',137.91,'right-arm offbreak','right-handed'),
('00052','Kuldeep Yadav','India','1994-12-14','Bowler',80.26,'left-arm chinaman','left-handed'),
('00053','Lockie Ferguson','New Zealand','1991-06-13','Bowler',148.89,'right-arm fast','right-handed'),
('00054','Sunil Narine','Jamaica','1983-05-26','Bowler',162.32,'right-arm offbreak','left-handed'),
('00055','Nitish Rana','India','1993-12-27','Batsman',134.97,'right-arm offbreak','left-handed'),
('00056', 'Shimron Hetmyer','Guyana','1996-12-26','Batsman','156.31', NULL,'left-handed'),				
('00057','Joe Root','England','1990-12-30','Batsman',NULL,'right-arm offbreak','right-handed'),
('00058','Ravichandran Ashwin','India','1986-09-17','All-rounder','118.52','right-arm offbreak','right-handed'),
('00059','Jason Holder','Barbados','1991-11-05','Bowler','123.38','right-arm fast-medium','right-handed'),
('00060','Sanju Samson','India','1994-11-11','Wicketkeeper','136.63',NULL,'right-handed'),
('00061','Jos Buttler','England','1990-09-08','Batsman','150.49',NULL,'right-handed'),
('00062','Trent Boult','New Zealand','1989-07-22','Bowler','108.16','left-arm fast-medium','right-handed'),
('00063','Sandeep Sharma','India','1993-05-18','Bowler','81.25','right-arm fast-medium','right-handed'),
('00064','Adam Zampa','Australia','1992-03-31','Bowler','66.67','right-arm legbreak','right-handed'),
('00065','Chris Gayle','Jamaica','1979-09-21','Batsman','189.65','right-arm fast-medium','left-handed'),
('00066','Vishwaraj Vedantam','Sri Lanka','1999-01-22','Wicketkeeper',102.24,'left-arm fast-medium','right-handed');


INSERT INTO TitleSponsor VALUES
('Vivo Mobile Pvt Ltd','Smartphone Company','China'), 
('Star Sports Network','Television Sports Channel Company','India'),
('Dream 11','Fantasy Sports Platform','India'),
('PhonePe','Financial Technology and Payments Company','India'),
('Myntra ','Fashion E-Commerce Company','India'),
('Aircel','Mobile Network Operator','India'),
('Muthoot Finance Ltd','Financial Corporation','India'),
('DHFL','Housing Finance Company','India'),
('Colors','General Entertainment Broadcast Company','India'),
('Puma','Athletic Footwear, Apparels and Accessories','Germany'),
('MPL','Online Gaming Platform ','India'),
('Kingfisher','Alcoholic Beverage Company','India'),
('Swiggy','Online Food Ordering & Delivering Platform','India'),
('Royal Stag','Alcoholic Beverage Company','India'),
('Colgate','Oral Hygiene Product Company','United States of America'),
('Mai Dubai','Food & Bevarage Company','Dubai'),
('Kotak Mahindra Bank','Banking and Financial Services Company','India'),
('Kent RO Systems','Healthcare Products Company','India');


INSERT INTO TeamOwner VALUES
('Red Chillies Entertainment','Film Industry','India'),
('Reliance Industry Ltd','Telecommunications, Energy','India'),
('CVC Capital Partners','Investment Advisory Firm','England'),
('United Spirits','Alcoholic Beverages Company','England'),
('Emerging Media IPL Ltd','Digital Venture Builder','England'),
('India Cements Ltd', 'Cement Manufacturing','India');


INSERT INTO HeadCoach VALUES
('10101','Jacques Kallis',10,'1975-10-16','South Africa'),
('10103','Paddy Upton',20,'1968-11-05','South Africa'),
('10104','Gary Kirsten',24,'1967-11-23','South Africa'),
('10105','Mark Boucher',17,'1976-12-03','South Africa'),
('10106','Ashish Nehra',4,'1979-04-29','India'),
('10107','Kumar Sngakkara',2,'1977-12-27','Sri Lanka'),
('10108','Andy Flower',5,'1968-04-28','Zimbabwe'),
('10109','Sanjay Bangar',19,'1972-10-11','India'),
('10110','Chandrakant Pandit',18,'1961-09-30','India'),
('10111','Anil Kumble',27,'1970-12-17','India'),
('10112','Trevor Bayliss',13,'1962-12-21','Australia');




INSERT INTO Umpire VALUES
('00001','Sundaram Ravi',15,'Inida'),							
('00002','Paul Reiffel',18,'Australia'),
('00003','Nitin Menon',9,'India'),
('00004','Christopher Columbus',25,'New Zealand'),
('00005','Anil Chaudary',10,'Inida'),
('00006','C. Shamshuddin',20,'India'),
('00007','Arvindra Gohel',9,'USA'),
('00008','Sumukh Chattopadhay',14,'India'),
('00009','Gerard Abood',23,'Australia'),
('00010','Afzal Ahmed',12,'India');

INSERT INTO Teams VALUES
('RCB','Royal Challengers Bangalore','United Spirits'), 
('MI','Mumbai Indians','Reliance Industry Ltd'),
('CSK','Chennai Super Kings','India Cements Ltd'),
('GT','Gujarat Titans','CVC Capital Partners'),
('RR','Rajasthan Royals','Emerging Media IPL Ltd'),
('KKR','Kolkata Knight Riders','Red Chillies Entertainment');

INSERT INTO Stadium VALUES
('Narendra Modi Stadium','Ahmedabad','India',132000,4000000),		
('M.Chinnaswamy Stadium','Banglore','India',40000,1200000),
('MA Chidambaram','Chennai','India',50000,1500000),
('Dubai International Cricket Stadium','Dubai','UAE',33000,990000),
('Wankhede Stadium','Mumbai','India',33000,990000),
('Sawai Mansingh Stadium','Jaipur','India',30000,900000),
('Arun Jaitley Stadium','New Delhi','India',41000,1230000),
('Rajiv Gandhi International Cricket Stadium','Hyderabad','India',55000,1650000),
('Eden Gardens','Kolkata','India',68000,2040000);

INSERT INTO "Match" VALUES
('2015001','League','2015-03-27','Wankhede Stadium','Mumbai','00012'),
('2015002','League','2015-03-29','Sawai Mansingh Stadium','Jaipur','00057'),
('2015003','League','2015-04-02','Arun Jaitley Stadium','New Delhi','00042'),
('2015004','League','2015-04-05','Sawai Mansingh Stadium','Jaipur','00020'),
('2015005','League','2015-04-07','Arun Jaitley Stadium','New Delhi','00029'),
('2015011','Semifinal','2015-04-10','Rajiv Gandhi International Cricket Stadium','Hyderabad','00040'),
('2015012','Semifinal','2015-04-12','Narendra Modi Stadium','Ahmedabad','00012'),
('2015021','Final','2015-04-16','Narendra Modi Stadium','Ahmedabad','00038'),
('2019001','League','2019-03-21','M.Chinnaswamy Stadium','Banglore','00059'),
('2019002','League','2019-03-25','MA Chidambaram','Chennai','00052'),
('2019003','League','2019-03-28','Eden Gardens','Kolkata','00039'),
('2019004','League','2019-04-02','M.Chinnaswamy Stadium','Banglore','00017'),
('2019005','League','2019-04-04','MA Chidambaram','Chennai','00038'),
('2019011','Semifinal','2019-04-10','Dubai International Cricket Stadium','Dubai','00038'),
('2019012','Semifinal','2019-04-12','Dubai International Cricket Stadium','Dubai','00009'),
('2019021','Final','2019-04-18','Narendra Modi Stadium','Ahmedabad','00036'),
('2022001','League','2022-04-15','Eden Gardens','Kolkata','00014'),
('2022002','League','2022-04-17','Sawai Mansingh Stadium','Jaipur','00056'),
('2022003','League','2022-04-18','Narendra Modi Stadium','Ahmedabad','00010'),
('2022004','League','2022-04-19','M.Chinnaswamy Stadium','Banglore','00025'),
('2022005','League','2022-04-20','M.Chinnaswamy Stadium','Banglore','00027'),
('2022006','League','2022-04-22','Wankhede Stadium','Mumbai','00036'),
('2022007','League','2022-04-23','Wankhede Stadium','Mumbai','00002'),
('2022008','League','2022-04-24','Arun Jaitley Stadium','New Delhi','00059'),
('2022009','League','2022-04-25','MA Chidambaram','Chennai','00013'),
('2022011','Semifinal','2022-05-01','Dubai International Cricket Stadium','Dubai','00011'),
('2022012','Semifinal','2022-05-02','Rajiv Gandhi International Cricket Stadium','Hyderabad','00066'),
('2022021','Final','2022-05-07','Narendra Modi Stadium','Ahmedabad','00001');


INSERT INTO UmpiredBy VALUES
('2015001','00001'),
('2015001','00002'),
('2015001','00003'),
('2015002','00004'),
('2015002','00005'),
('2015002','00006'),
('2015003','00007'),
('2015003','00008'),
('2015003','00009'),
('2015004','00010'),
('2015004','00001'),
('2015004','00002'),
('2015005','00003'),
('2015005','00004'),
('2015005','00005'),
('2015011','00006'),
('2015011','00007'),
('2015011','00008'),
('2015012','00009'),
('2015012','00010'),
('2015012','00001'),
('2015021','00002'),
('2015021','00003'),
('2015021','00004'),
('2019001','00005'),
('2019001','00006'),
('2019001','00007'),
('2019002','00008'),
('2019002','00009'),
('2019002','00010'),
('2019003','00001'),
('2019003','00002'),
('2019003','00003'),
('2019004','00004'),
('2019004','00005'),
('2019004','00006'),
('2019005','00007'),
('2019005','00008'),
('2019005','00009'),
('2019011','00010'),
('2019011','00001'),
('2019011','00002'),
('2019012','00003'),
('2019012','00004'),
('2019012','00005'),
('2019021','00006'),
('2019021','00007'),
('2019021','00008'),
('2022001','00009'),
('2022001','00010'),
('2022001','00001'),
('2022002','00002'),
('2022002','00003'),
('2022002','00004'),
('2022003','00005'),
('2022003','00006'),
('2022003','00007'),
('2022004','00008'),
('2022004','00009'),
('2022004','00010'),
('2022005','00001'),
('2022005','00002'),
('2022005','00003'),
('2022006','00004'),
('2022006','00005'),
('2022006','00006'),
('2022007','00007'),
('2022007','00008'),
('2022007','00009'),
('2022008','00010'),
('2022008','00001'),
('2022008','00002'),
('2022009','00003'),
('2022009','00004'),
('2022009','00005'),
('2022011','00006'),
('2022011','00007'),
('2022011','00008'),
('2022012','00009'),
('2022012','00010'),
('2022012','00001'),
('2022021','00002'),
('2022021','00003'),
('2022021','00004');

INSERT INTO IPL VALUES
(2015,'Dream 11','00046','MI'),
(2019,'MPL','00061','MI'),
(2022,'Vivo Mobile Pvt Ltd','00023','GT');

INSERT INTO teamdetails VALUES
('RCB',2015,'00023','10109','Star Sports Network',980000000),
('CSK',2015,'00012','10104','Kent RO Systems',700000000),
('RR',2015,'00060','10108','Myntra ',300000000),
('MI',2015,'00034','10111','PhonePe',830000000),
('KKR',2015,'00045','10107','Aircel',470000000),
('RCB',2019,'00023','10101','Muthoot Finance Ltd',230000000),
('CSK',2019,'00012','10103','DHFL',610000000),
('RR',2019,'00058','10105','Royal Stag',490000000),
('MI',2019,'00034','10110','Colors',800000000),
('KKR',2019,'00049','10107','Puma',190000000),
('RCB',2022,'00023','10101','Kingfisher',980000000),
('CSK',2022,'00012','10104','Swiggy',280000000),
('RR',2022,'00060','10112','Royal Stag',310000000),
('MI',2022,'00034','10111','Colgate',940000000),
('KKR',2022,'00049','10106','Mai Dubai',820000000),
('GT',2022,'00001','10108','Kotak Mahindra Bank',380000000);



INSERT INTO YearWisePlayerDetails VALUES
('00012',2015,'CSK',4,229,2,45,114,170000000,FALSE),
('00013',2015,'CSK',0,137,0,29,87,160000000,TRUE),
('00014',2015,'CSK',4,213,3,25,108,20000000,FALSE),
('00015',2015,'CSK',6,39,4,36,25,150000000,TRUE),
('00001',2015,'CSK',3,95,2,8,87,110000000,FALSE),
('00017',2015,'CSK',0,160,0,31,69,50000000,FALSE),
('00018',2015,'CSK',6,231,6,28,82,110000000,FALSE),
('00019',2015,'CSK',8,3,5,15,3,170000000,TRUE),
('00020',2015,'CSK',5,142,3,11,122,110000000,FALSE),
('00021',2015,'CSK',1,125,1,14,80,50000000,TRUE),
('00022',2015,'CSK',8,56,6,17,38,140000000,FALSE),
('00023',2015,'RCB',5,13,4,42,10,10000000,TRUE),
('00024',2015,'RCB',1,47,1,34,24,170000000,TRUE),
('00004',2015,'RCB',6,191,5,14,79,150000000,FALSE),
('00026',2015,'RCB',3,52,2,30,46,170000000,FALSE),
('00027',2015,'RCB',7,56,5,50,48,130000000,FALSE),
('00002',2015,'RCB',5,12,2,43,9,100000000,FALSE),
('00029',2015,'RCB',5,228,3,26,97,20000000,TRUE),
('00030',2015,'RCB',6,87,3,29,48,140000000,TRUE),
('00031',2015,'RCB',4,111,2,32,58,60000000,FALSE),
('00032',2015,'RCB',4,244,3,15,93,170000000,FALSE),
('00003',2015,'RCB',6,257,4,24,93,150000000,FALSE),
('00034',2015,'MI',0,41,0,36,39,100000000,TRUE),
('00035',2015,'MI',5,209,2,42,105,50000000,FALSE),
('00036',2015,'MI',0,146,0,29,91,100000000,TRUE),
('00037',2015,'MI',8,54,6,45,37,60000000,FALSE),
('00038',2015,'MI',5,15,4,42,14,130000000,FALSE),
('00039',2015,'MI',5,50,2,45,31,20000000,TRUE),
('00040',2015,'MI',NULL,251,NULL,NULL,140,80000000,FALSE),
('00041',2015,'MI',NULL,99,NULL,NULL,73,30000000,TRUE),
('00042',2015,'MI',1,134,1,14,129,20000000,TRUE),
('00043',2015,'MI',2,224,1,5,90,20000000,TRUE),
('00044',2015,'MI',1,68,1,2,42,90000000,TRUE),
('00045',2015,'KKR',0,94,0,2,56,60000000,FALSE),
('00046',2015,'KKR',5,81,3,12,55,130000000,FALSE),
('00047',2015,'KKR',3,217,2,22,131,10000000,TRUE),
('00048',2015,'KKR',0,106,0,6,91,110000000,FALSE),
('00049',2015,'KKR',NULL,209,NULL,NULL,88,160000000,TRUE),
('00050',2015,'KKR',NULL,105,NULL,NULL,61,10000000,TRUE),
('00051',2015,'KKR',6,260,4,27,101,150000000,TRUE),
('00052',2015,'KKR',4,164,2,49,58,120000000,TRUE),
('00053',2015,'KKR',3,49,1,46,26,140000000,TRUE),
('00054',2015,'KKR',8,65,5,37,53,150000000,FALSE),
('00055',2015,'KKR',0,194,0,22,88,170000000,FALSE),
('00056',2015,'RR',NULL,100,NULL,NULL,57,80000000,FALSE),
('00057',2015,'RR',4,114,3,20,102,90000000,FALSE),
('00058',2015,'RR',4,123,2,21,84,130000000,TRUE),
('00059',2015,'RR',8,166,5,25,62,170000000,TRUE),
('00060',2015,'RR',NULL,35,NULL,NULL,32,20000000,FALSE),
('00061',2015,'RR',NULL,122,NULL,NULL,73,150000000,FALSE),
('00062',2015,'RR',3,41,2,47,24,110000000,FALSE),
('00063',2015,'RR',1,253,1,8,165,80000000,TRUE),
('00064',2015,'RR',3,255,2,5,125,70000000,TRUE),
('00065',2015,'RR',2,31,2,0,17,140000000,TRUE),
('00066',2015,'RR',5,84,3,45,81,70000000,FALSE),
('00012',2019,'CSK',1,214,1,14,90,40000000,TRUE),
('00013',2019,'CSK',0,133,0,34,69,10000000,TRUE),
('00014',2019,'CSK',8,62,5,32,58,80000000,FALSE),
('00015',2019,'CSK',6,51,4,48,50,80000000,FALSE),
('00016',2019,'CSK',1,81,1,10,46,140000000,FALSE),
('00017',2019,'CSK',8,221,6,44,103,170000000,TRUE),
('00018',2019,'CSK',7,180,3,2,85,30000000,FALSE),
('00019',2019,'CSK',2,283,1,43,176,30000000,TRUE),
('00020',2019,'CSK',3,284,1,40,180,80000000,FALSE),
('00021',2019,'CSK',2,35,2,14,32,40000000,TRUE),
('00022',2019,'CSK',6,110,2,48,81,90000000,TRUE),
('00023',2019,'RCB',7,136,5,42,95,100000000,FALSE),
('00024',2019,'RCB',4,294,3,37,119,30000000,TRUE),
('00025',2019,'RCB',2,250,1,7,166,120000000,FALSE),
('00026',2019,'RCB',8,181,4,3,77,50000000,FALSE),
('00027',2019,'RCB',6,0,4,48,0,120000000,FALSE),
('00028',2019,'RCB',1,217,1,47,96,70000000,TRUE),
('00029',2019,'RCB',2,259,2,48,150,90000000,FALSE),
('00030',2019,'RCB',3,226,2,18,87,20000000,TRUE),
('00031',2019,'RCB',3,300,3,23,166,130000000,FALSE),
('00010',2019,'RCB',5,277,3,40,132,140000000,FALSE),
('00033',2019,'RCB',NULL,92,NULL,NULL,47,110000000,FALSE),
('00034',2019,'MI',2,153,1,11,63,80000000,FALSE),
('00035',2019,'MI',3,177,2,29,70,100000000,TRUE),
('00036',2019,'MI',2,41,2,26,39,10000000,FALSE),
('00037',2019,'MI',4,239,3,23,94,130000000,FALSE),
('00038',2019,'MI',8,110,5,23,66,170000000,TRUE),
('00039',2019,'MI',0,271,0,3,121,20000000,TRUE),
('00040',2019,'MI',NULL,141,NULL,NULL,116,80000000,TRUE),
('00041',2019,'MI',NULL,151,NULL,NULL,100,110000000,TRUE),
('00042',2019,'MI',7,5,3,30,3,60000000,FALSE),
('00043',2019,'MI',6,114,3,43,76,170000000,TRUE),
('00044',2019,'MI',8,56,4,8,30,80000000,TRUE),
('00045',2019,'KKR',0,85,0,16,47,110000000,FALSE),
('00049',2019,'KKR',NULL,55,NULL,NULL,47,100000000,FALSE),
('00047',2019,'KKR',4,248,2,29,108,80000000,TRUE),
('00008',2019,'KKR',0,33,0,33,23,50000000,FALSE),
('00009',2019,'KKR',2,273,2,3,155,60000000,TRUE),
('00050',2019,'KKR',NULL,137,NULL,NULL,111,80000000,TRUE),
('00007',2019,'KKR',NULL,19,NULL,NULL,18,150000000,FALSE),
('00052',2019,'KKR',7,10,3,47,5,160000000,TRUE),
('00053',2019,'KKR',3,270,2,33,97,40000000,FALSE),
('00054',2019,'KKR',7,57,3,34,47,100000000,FALSE),
('00006',2019,'KKR',0,292,0,26,182,70000000,FALSE),
('00056',2019,'RR',NULL,245,NULL,NULL,106,110000000,FALSE),
('00005',2019,'RR',4,190,2,31,74,70000000,FALSE),
('00058',2019,'RR',7,185,5,0,107,160000000,FALSE),
('00059',2019,'RR',6,120,5,32,94,80000000,TRUE),
('00060',2019,'RR',NULL,73,NULL,NULL,45,160000000,TRUE),
('00061',2019,'RR',NULL,99,NULL,NULL,98,60000000,TRUE),
('00062',2019,'RR',4,235,3,5,151,120000000,TRUE),
('00063',2019,'RR',3,263,1,3,124,10000000,FALSE),
('00064',2019,'RR',4,57,3,30,47,120000000,FALSE),
('00065',2019,'RR',3,95,2,35,53,30000000,FALSE),
('00066',2019,'RR',4,68,2,16,39,90000000,TRUE),
('00001',2022,'GT',5,149,4,41,112,50000000,TRUE),
('00002',2022,'GT',5,56,3,11,50,120000000,TRUE),
('00003',2022,'GT',0,148,0,15,142,110000000,FALSE),
('00004',2022,'GT',7,238,3,2,88,160000000,TRUE),
('00005',2022,'GT',6,248,2,21,138,150000000,TRUE),
('00006',2022,'GT',3,246,3,26,107,20000000,TRUE),
('00007',2022,'GT',NULL,289,NULL,NULL,176,80000000,FALSE),
('00008',2022,'GT',0,168,0,27,78,70000000,FALSE),
('00009',2022,'GT',0,214,0,29,140,50000000,FALSE),
('00010',2022,'GT',6,320,2,29,154,30000000,FALSE),
('00011',2022,'GT',3,204,1,34,70,170000000,FALSE),
('00012',2022,'CSK',6,328,2,14,129,40000000,TRUE),
('00013',2022,'CSK',7,11,3,34,11,40000000,FALSE),
('00014',2022,'CSK',1,215,1,22,79,60000000,TRUE),
('00015',2022,'CSK',2,27,1,3,26,40000000,FALSE),
('00016',2022,'CSK',4,64,2,41,56,90000000,FALSE),
('00017',2022,'CSK',7,338,6,7,192,160000000,FALSE),
('00018',2022,'CSK',7,239,3,17,113,10000000,FALSE),
('00019',2022,'CSK',1,86,1,3,74,120000000,TRUE),
('00020',2022,'CSK',0,262,0,44,147,160000000,FALSE),
('00021',2022,'CSK',1,41,1,38,25,100000000,FALSE),
('00022',2022,'CSK',8,121,3,35,116,70000000,TRUE),
('00023',2022,'RCB',0,290,0,5,144,130000000,FALSE),
('00024',2022,'RCB',7,166,6,9,74,20000000,FALSE),
('00025',2022,'RCB',8,147,5,14,84,10000000,TRUE),
('00026',2022,'RCB',6,80,4,6,54,120000000,TRUE),
('00027',2022,'RCB',3,70,2,27,45,160000000,FALSE),
('00028',2022,'RCB',3,28,1,8,23,160000000,TRUE),
('00029',2022,'RCB',8,88,4,28,57,170000000,FALSE),
('00030',2022,'RCB',1,151,1,14,60,10000000,FALSE),
('00031',2022,'RCB',5,103,4,35,78,40000000,TRUE),
('00032',2022,'RCB',3,68,3,12,62,170000000,FALSE),
('00033',2022,'RCB',NULL,4,NULL,NULL,3,20000000,FALSE),
('00034',2022,'MI',2,286,2,1,159,170000000,TRUE),
('00035',2022,'MI',8,301,4,22,123,80000000,FALSE),
('00036',2022,'MI',0,133,0,2,78,140000000,TRUE),
('00037',2022,'MI',8,252,5,26,138,70000000,FALSE),
('00038',2022,'MI',6,109,4,11,70,70000000,TRUE),
('00039',2022,'MI',6,333,2,48,189,160000000,FALSE),
('00040',2022,'MI',NULL,104,NULL,NULL,66,160000000,FALSE),
('00041',2022,'MI',NULL,213,NULL,NULL,129,30000000,FALSE),
('00042',2022,'MI',7,8,5,46,6,170000000,TRUE),
('00043',2022,'MI',7,305,3,6,116,100000000,TRUE),
('00044',2022,'MI',7,299,2,26,106,140000000,TRUE),
('00045',2022,'KKR',3,117,1,50,108,140000000,TRUE),
('00046',2022,'KKR',6,199,2,2,112,70000000,TRUE),
('00047',2022,'KKR',8,291,3,9,135,120000000,TRUE),
('00048',2022,'KKR',8,330,4,30,175,60000000,TRUE),
('00049',2022,'KKR',NULL,101,NULL,NULL,61,20000000,FALSE),
('00050',2022,'KKR',NULL,41,NULL,NULL,30,130000000,FALSE),
('00051',2022,'KKR',2,220,1,31,90,170000000,FALSE),
('00052',2022,'KKR',5,29,2,49,18,10000000,FALSE),
('00053',2022,'KKR',3,245,2,15,139,70000000,TRUE),
('00054',2022,'KKR',5,139,3,18,88,100000000,TRUE),
('00055',2022,'KKR',1,71,1,2,59,20000000,FALSE),
('00056',2022,'RR',NULL,46,NULL,NULL,27,40000000,TRUE),
('00057',2022,'RR',1,211,1,35,78,70000000,TRUE),
('00058',2022,'RR',3,311,2,49,111,130000000,TRUE),
('00059',2022,'RR',6,189,3,12,74,110000000,TRUE),
('00060',2022,'RR',NULL,343,NULL,NULL,127,30000000,FALSE),
('00061',2022,'RR',NULL,212,NULL,NULL,126,10000000,TRUE),
('00062',2022,'RR',0,140,0,46,83,90000000,FALSE),
('00063',2022,'RR',1,165,1,46,56,100000000,TRUE),
('00064',2022,'RR',8,15,4,3,13,110000000,FALSE),
('00065',2022,'RR',4,88,2,19,46,60000000,FALSE),
('00066',2022,'RR',0,77,0,12,60,70000000,FALSE);

INSERT INTO played VALUES
('2015001','RR',123,11,2,5,'0'),
('2015001','CSK',125,13,3,7,'1'),
('2015002','RR',180,14,4,5,'1'),
('2015002','RCB',177,11,3,9,'0'),
('2015003','KKR',130,9,3,10,'0'),
('2015003','MI',190,10,6,3,'1'),
('2015004','KKR',213,15,6,9,'0'),
('2015004','CSK',214,12,5,9,'1'),
('2015005','MI',200,16,7,10,'0'),
('2015005','RCB',224,9,6,3,'1'),
('2015011','MI',240,13,6,9,'1'),
('2015011','RR',239,12,7,2,'0'),
('2015012','CSK',145,7,3,8,'1'),
('2015012','RCB',110,4,2,10,'0'),
('2015021','MI',240,18,8,8,'1'),
('2015021','CSK',239,14,4,5,'0'),
('2019001','RR',125,6,3,9,'1'),
('2019001','CSK',123,4,3,2,'0'),
('2019002','RR',76,3,1,10,'0'),
('2019002','KKR',170,6,6,4,'1'),
('2019003','RCB',201,8,6,7,'0'),
('2019003','MI',203,9,5,9,'1'),
('2019004','RCB',189,7,4,2,'0'),
('2019004','CSK',191,9,3,3,'1'),
('2019005','KKR',120,10,2,10,'0'),
('2019005','MI',193,16,4,4,'1'),
('2019011','MI',262,19,7,7,'1'),
('2019011','CSK',261,18,4,6,'0'),
('2019012','RR',90,6,3,10,'0'),
('2019012','KKR',180,13,5,3,'1'),
('2019021','MI',199,13,6,3,'1'),
('2019021','KKR',198,10,4,6,'0'),
('2022001','CSK',212,15,6,7,'1'),
('2022001','KKR',202,9,6,10,'0'),
('2022002','RR',200,6,4,8,'1'),
('2022002','KKR',199,7,6,5,'0'),
('2022003','GT',150,5,3,2,'1'),
('2022003','KKR',60,2,1,10,'0'),
('2022004','GT',144,7,5,6,'0'),
('2022004','RCB',145,5,3,4,'1'),
('2022005','RCB',223,9,7,7,'1'),
('2022005','CSK',178,9,3,10,'0'),
('2022006','MI',195,9,6,4,'1'),
('2022006','RCB',192,8,4,3,'0'),
('2022007','GT',257,14,8,6,'1'),
('2022007','MI',230,11,7,5,'0'),
('2022008','RR',182,10,6,2,'1'),
('2022008','MI',181,8,5,9,'0'),
('2022009','CSK',127,5,4,4,'1'),
('2022009','RR',122,4,3,6,'0'),
('2022011','GT',189,13,6,8,'1'),
('2022011','RCB',142,11,4,10,'0'),
('2022012','RR',216,17,8,3,'1'),
('2022012','CSK',116,6,5,2,'0'),
('2022021','GT',200,16,7,2,'1'),
('2022021','RR',176,7,3,9,'0');