CRICKET WORLD CUP SCORES(1975-2019
Scores of each match played in the World Cup from 1975 to 2019
@kaggle.amalab182_cricket_world_cup_scores1975_2019
Scores of each match played in the World Cup from 1975 to 2019
@kaggle.amalab182_cricket_world_cup_scores1975_2019
CREATE TABLE cricket_world_cup_1975 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1979 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1983 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1987 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1992 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1996 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_1999 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2003 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2007 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" DOUBLE,
"wickets_lost" DOUBLE,
"wickets_taken" DOUBLE,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2011 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2015 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
CREATE TABLE cricket_world_cup_2019 (
"year" DOUBLE,
"team" VARCHAR,
"runs_scored" VARCHAR,
"wickets_lost" VARCHAR,
"wickets_taken" VARCHAR,
"against" VARCHAR,
"result" VARCHAR,
"venue" VARCHAR,
"winner" VARCHAR
);
Anyone who has the link will be able to view this.