SQLize Online / PHPize Online  /  SQLtest Online

create table cricinfo ( playerId int(255), playerName varchar(255), State varchar(255), oponentTeam varchar(255), matchType varchar(255), DateOfMatch Date, Score int(255), Wickets int(255)); ----------------------------------- insert into cricinfo values(001,'Sachin Tendulkar', 'Maharashtra','Pakistan','ODI','1995-05-12',201,0), (001,'Sachin Tendulkar', 'Maharashtra','Pakistan','ODI','2000-01-25',42,3), (003,'Rohit Sharma', 'Maharashtra','Australia','ODI','2020-01-30',40,0), (004,'Jasprit Bumrah', 'Maharashtra','Srilanka','ODI','2015-07-12',0,6), (001,'Sachin Tendulkar', 'Maharashtra','SouthAfrica','ODI','2008-02-07',90,0), (001,'Sachin Tendulkar', 'Maharashtra','Australia','ODI','2002-09-10',185,1), (003,'Rohit Sharma', 'Maharashtra','Pakistan','ODI','2015-01-08',99,0), (001,'Sachin Tendulkar', 'Maharashtra','Australia','ODI','2005-11-20',0,0), (001,'Sachin Tendulkar', 'Maharashtra','England','T20','2012-07-23',58,0), (004,'Jasprit Bumrah', 'Maharashtra','England','ODI','2005-08-18',0,5), (002,'Yuvraj Singh', 'Punjab','England','Test','2014-02-10',174,2), (002,'Yuvraj Singh', 'Punjab','Srilanka','T20','2018-01-12',10,0), (001,'Sachin Tendulkar', 'Maharashtra','Srilanka','T20','2010-08-30',101,5), (004,'Jasprit Bumrah', 'Maharashtra','Srilanka','T20','2018-01-12',0,3), (003,'Rohit Sharma', 'Maharashtra','England','T20','2019-01-21',121,0), (002,'Yuvraj Singh', 'Punjab','England','T20','2005-04-05',0,6), (002,'Yuvraj Singh', 'Punjab','Pakistan','ODI','2015-03-15',151,3), (004,'Jasprit Bumrah', 'Maharashtra','Pakistan','Test','2012-07-12',0,7), (002,'Yuvraj Singh', 'Punjab','Australia','ODI','2012-12-12',89,1), (002,'Yuvraj Singh', 'Punjab','SouthAfrica','ODI','2016-09-24',65,2), (004,'Jasprit Bumrah', 'Maharashtra','WestIndies','ODI','2017-09-25',0,4), (003,'Rohit Sharma', 'Maharashtra','Srilanka','ODI','2011-05-12',191,0), (003,'Rohit Sharma', 'Maharashtra','Srilanka','Test','2014-08-21',345,0);