PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "matches" (
"loser_age" FLOAT,
"loser_name" TEXT,
"winner_age" FLOAT,
"winner_name" TEXT
);

CREATE TABLE "players" (
"player_id" INT,
"birth_date" DATE,
PRIMARY KEY ("player_id")
);





INSERT INTO "matches" VALUES ("25.5", "Serena Williams", "23.1", "Maria Sharapova");
INSERT INTO "matches" VALUES ("28.0", "Victoria Azarenka", "26.7", "Simona Halep");
INSERT INTO "matches" VALUES ("22.3", "Naomi Osaka", "20.9", "Ashleigh Barty");
INSERT INTO "matches" VALUES ("30.1", "Angelique Kerber", "29.5", "Petra Kvitova");
INSERT INTO "matches" VALUES ("19.8", "Coco Gauff", "21.2", "Iga Swiatek");
INSERT INTO "matches" VALUES ("27.4", "Elina Svitolina", "24.0", "Aryna Sabalenka");
INSERT INTO "matches" VALUES ("33.6", "Venus Williams", "28.9", "Garbiñe Muguruza");
INSERT INTO "matches" VALUES ("26.0", "Karolina Pliskova", "26.0", "Madison Keys");
INSERT INTO "matches" VALUES ("20.0", "Emma Raducanu", "20.0", "Leylah Fernandez");
INSERT INTO "matches" VALUES ("35.2", "Roger Federer", "35.2", "Rafael Nadal");
INSERT INTO "matches" VALUES ("17.5", "Mirra Andreeva", "22.8", "Ons Jabeur");
INSERT INTO "matches" VALUES ("40.0", "Martina Hingis", "25.0", "Anna Kournikova");
INSERT INTO "matches" VALUES ("29.9", "Bianca Andreescu", "27.1", "Danielle Collins");
INSERT INTO "matches" VALUES ("23.7", "Jessica Pegula", "25.3", "Elena Rybakina");
INSERT INTO "matches" VALUES ("21.0", "Qinwen Zheng", "24.5", "Veronika Kudermetova");