Who will win the 2022 Football World Cup ?

This data set contain a file about the teams participating in the 2022 Football World Cup (by group), and another file containing the schedule of the matches from group matches until final.
Using other existing data in Kaggle related to results of matches, try to find out who will win this World Cup !
Other files will be added as soon as available : composition of teams for example.

Tables

Historical Win Loose Draw Ratios Qatar2022 Teams

@kaggle.amineteffal_qatar2022worldcupschudule.historical_win_loose_draw_ratios_qatar2022_teams

11.22 KB
798 rows
6 columns


CREATE TABLE historical_win_loose_draw_ratios_qatar2022_teams (
  "country1" VARCHAR,
  "country2" VARCHAR,
  "games" BIGINT,
  "wins" DOUBLE,
  "looses" DOUBLE,
  "draws" DOUBLE
);

Matchs Schudule

@kaggle.amineteffal_qatar2022worldcupschudule.matchs_schudule

5.26 KB
64 rows
5 columns


CREATE TABLE matchs_schudule (
  "match" BIGINT,
  "date" TIMESTAMP,
  "country1" VARCHAR,
  "coutry2" VARCHAR,
  "phase" VARCHAR
);

Qatar2022 Teams

@kaggle.amineteffal_qatar2022worldcupschudule.qatar2022_teams

2.29 KB
32 rows
2 columns


CREATE TABLE qatar2022_teams (
  "team" VARCHAR,
  "group" VARCHAR
);