A Comprehensive Database On The FIFA World Cup

key_id Key Id	tournament_id Tournament Id	tournament_name Tournament Name	stage_number Stage Number	stage_name Stage Name	group_name Group Name	count_teams Count Teams
1	WC-1930	1930 FIFA World Cup	1	group stage	Group 1	4
2	WC-1930	1930 FIFA World Cup	1	group stage	Group 2	3
3	WC-1930	1930 FIFA World Cup	1	group stage	Group 3	3
4	WC-1930	1930 FIFA World Cup	1	group stage	Group 4	3
5	WC-1950	1950 FIFA World Cup	1	first round	Group 1	4
6	WC-1950	1950 FIFA World Cup	1	first round	Group 2	4
7	WC-1950	1950 FIFA World Cup	1	first round	Group 3	3
8	WC-1950	1950 FIFA World Cup	1	first round	Group 4	2
9	WC-1950	1950 FIFA World Cup	2	final round	Group 1	4
10	WC-1954	1954 FIFA World Cup	1	group stage	Group 1	4


CREATE TABLE groups (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "stage_number" BIGINT,
  "stage_name" VARCHAR,
  "group_name" VARCHAR,
  "count_teams" BIGINT
);