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	position Position	team_id Team Id	team_name Team Name	team_code Team Code	played Played	wins Wins	losses Losses	goals_for Goals For	goals_against Goals Against	goal_difference Goal Difference	points Points	advanced Advanced
1	WC-1930	1930 FIFA World Cup	1	group stage	Group 1	1	T-03	Argentina	ARG	3	3		10	4	6	6	1
2	WC-1930	1930 FIFA World Cup	1	group stage	Group 1	2	T-13	Chile	CHL	3	2	1	5	3	2	4
3	WC-1930	1930 FIFA World Cup	1	group stage	Group 1	3	T-28	France	FRA	3	1	2	4	3	1	2
4	WC-1930	1930 FIFA World Cup	1	group stage	Group 1	4	T-44	Mexico	MEX	3		3	4	13	-9
5	WC-1930	1930 FIFA World Cup	1	group stage	Group 2	1	T-83	Yugoslavia	YUG	2	2		6	1	5	4	1
6	WC-1930	1930 FIFA World Cup	1	group stage	Group 2	2	T-09	Brazil	BRA	2	1	1	5	2	3	2
7	WC-1930	1930 FIFA World Cup	1	group stage	Group 2	3	T-07	Bolivia	BOL	2		2		8	-8
8	WC-1930	1930 FIFA World Cup	1	group stage	Group 3	1	T-80	Uruguay	URY	2	2		5		5	4	1
9	WC-1930	1930 FIFA World Cup	1	group stage	Group 3	2	T-58	Romania	ROU	2	1	1	3	5	-2	2
10	WC-1930	1930 FIFA World Cup	1	group stage	Group 3	3	T-54	Peru	PER	2		2	1	4	-3


CREATE TABLE group_standings (
  "key_id" BIGINT,
  "tournament_id" VARCHAR,
  "tournament_name" VARCHAR,
  "stage_number" BIGINT,
  "stage_name" VARCHAR,
  "group_name" VARCHAR,
  "position" BIGINT,
  "team_id" VARCHAR,
  "team_name" VARCHAR,
  "team_code" VARCHAR,
  "played" BIGINT,
  "wins" BIGINT,
  "draws" BIGINT,
  "losses" BIGINT,
  "goals_for" BIGINT,
  "goals_against" BIGINT,
  "goal_difference" BIGINT,
  "points" BIGINT,
  "advanced" BIGINT
);