Team Records In One-day Internationals Cricket
Statistical analysis of team performances in one-day internationals,
@kaggle.tariqsays_team_records_in_one_day_internationals_cricket
Statistical analysis of team performances in one-day internationals,
@kaggle.tariqsays_team_records_in_one_day_internationals_cricket
CREATE TABLE most_fours_in_an_innings (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT,
"n_6s" BIGINT,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_fours_in_a_match (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT,
"n_6s" BIGINT,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_runs_from_fours_and_sixes_in_an_innings (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT,
"n_6s" BIGINT,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_runs_from_fours_and_sixes_in_a_match (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT,
"n_6s" BIGINT,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_sixes_in_an_innings (
"team" VARCHAR,
"score" VARCHAR,
"n_4s" BIGINT,
"n_6s" BIGINT,
"inns" BIGINT,
"result" VARCHAR,
"opposition" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
CREATE TABLE most_sixes_in_a_match (
"team_1" VARCHAR,
"team_2" VARCHAR,
"n_4s" BIGINT,
"n_6s" BIGINT,
"runs" BIGINT,
"winner" VARCHAR,
"ground" VARCHAR,
"match_date" VARCHAR,
"scorecard" VARCHAR
);
Anyone who has the link will be able to view this.