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,
"loser_rank" INT,
"winner_age" FLOAT,
"winner_name" TEXT,
"winner_rank" INT
);





INSERT INTO "matches" VALUES ("25.1", "Player A", "50", "20.5", "Winner X", "10");
INSERT INTO "matches" VALUES ("28.3", "Player B", "60", "22.0", "Winner Y", "15");
INSERT INTO "matches" VALUES ("30.0", "Player C", "70", "19.8", "Winner Z", "5");
INSERT INTO "matches" VALUES ("22.5", "Player D", "40", "21.2", "Winner W", "20");
INSERT INTO "matches" VALUES ("26.7", "Player E", "55", "23.5", "Winner V", "25");
INSERT INTO "matches" VALUES ("29.1", "Player F", "65", "19.5", "Winner U", "8");
INSERT INTO "matches" VALUES ("24.0", "Player G", "45", "20.0", "Winner T", "12");
INSERT INTO "matches" VALUES ("31.2", "Player H", "75", "24.1", "Winner S", "30");
INSERT INTO "matches" VALUES ("27.8", "Player I", "52", "21.8", "Winner R", "18");
INSERT INTO "matches" VALUES ("23.3", "Player J", "48", "20.7", "Winner Q", "11");
INSERT INTO "matches" VALUES ("35.0", "Player K", "80", "26.0", "Winner P", "35");
INSERT INTO "matches" VALUES ("21.0", "Player L", "30", "18.9", "Winner M", "3");
INSERT INTO "matches" VALUES ("27.0", "Player N", "58", "22.2", "Winner O", "16");