ICC Mens T20 World Cup 2024 Stats

CREATE TABLE batting_stats_for_icc_mens_t20_world_cup_2024 (
  "player" VARCHAR,
  "team" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "no" BIGINT,
  "runs" BIGINT,
  "hs" VARCHAR,
  "ave" DOUBLE,
  "sr" DOUBLE,
  "n_100" BIGINT  -- 100,
  "n_50" BIGINT  -- 50,
  "n_0" BIGINT  -- 0
);

CREATE TABLE bowling_stats_for_icc_mens_t20_world_cup_2024 (
  "player" VARCHAR,
  "team" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "balls" BIGINT,
  "mdns" BIGINT,
  "runs" BIGINT,
  "wkts" BIGINT,
  "bbi" VARCHAR,
  "ave" DOUBLE,
  "econ" DOUBLE,
  "sr" VARCHAR,
  "n_5" BIGINT  -- 5,
  "n_10" BIGINT  -- 10,
  "ct" BIGINT
);

CREATE TABLE fielding_stats_for_icc_mens_t20_world_cup_2024 (
  "player" VARCHAR,
  "team" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "ct" BIGINT,
  "max" BIGINT,
  "ct_inn" DOUBLE
);

CREATE TABLE match_results_for_icc_mens_t20_world_cup_2024 (
  "team_1" VARCHAR,
  "team_2" VARCHAR,
  "winner" VARCHAR,
  "margin" VARCHAR,
  "ground" VARCHAR,
  "match_date" TIMESTAMP
);

CREATE TABLE wk_stats_for_icc_mens_t20_world_cup_2024 (
  "player" VARCHAR,
  "team" VARCHAR,
  "mat" BIGINT,
  "inns" BIGINT,
  "dis" BIGINT,
  "ct" BIGINT,
  "st" BIGINT,
  "max_dis_inns" BIGINT,
  "dis_inn" DOUBLE
);