IPL2020

CREATE TABLE all_matches_details (
  "innings" VARCHAR,
  "delivery_no" BIGINT,
  "delivery_no_over" DOUBLE,
  "non_striker" VARCHAR,
  "bowler" VARCHAR,
  "runs_extras" BIGINT,
  "runs_total" BIGINT,
  "runs_batsman" BIGINT,
  "batsman" VARCHAR,
  "player_out" VARCHAR,
  "player_out_kind" VARCHAR,
  "match_no" BIGINT
);

CREATE TABLE iplt2020_all_matches (
  "venue" VARCHAR,
  "competition" VARCHAR,
  "dates" TIMESTAMP,
  "outcome_winner" VARCHAR,
  "outcome_wickets" DOUBLE,
  "outcome_runs" DOUBLE,
  "n_1st_innings_team" VARCHAR,
  "n_2nd_innings_team" VARCHAR,
  "player_of_match" VARCHAR,
  "match_no" BIGINT
);