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_name" TEXT,
"winner_name" TEXT
);

CREATE TABLE "players" (
"player_id" INT,
"first_name" TEXT,
"last_name" TEXT,
"hand" TEXT,
"birth_date" DATE,
PRIMARY KEY ("player_id")
);

CREATE TABLE "rankings" (
"ranking_date" DATE
);





INSERT INTO "matches" VALUES ("Serena Williams", "Naomi Osaka");
INSERT INTO "matches" VALUES ("Naomi Osaka", "Ashleigh Barty");
INSERT INTO "matches" VALUES ("Simona Halep", "Serena Williams");
INSERT INTO "matches" VALUES ("Ashleigh Barty", "Simona Halep");
INSERT INTO "matches" VALUES ("Petra Kvitova", "Karolina Pliskova");
INSERT INTO "matches" VALUES ("Karolina Pliskova", "Elina Svitolina");
INSERT INTO "matches" VALUES ("Elina Svitolina", "Bianca Andreescu");
INSERT INTO "matches" VALUES ("Bianca Andreescu", "Sofia Kenin");
INSERT INTO "matches" VALUES ("Sofia Kenin", "Garbine Muguruza");
INSERT INTO "matches" VALUES ("Garbine Muguruza", "Victoria Azarenka");
INSERT INTO "matches" VALUES ("Victoria Azarenka", "Angelique Kerber");
INSERT INTO "matches" VALUES ("Angelique Kerber", "Johanna Konta");
INSERT INTO "matches" VALUES ("Johanna Konta", "Madison Keys");
INSERT INTO "matches" VALUES ("Madison Keys", "Sloane Stephens");
INSERT INTO "matches" VALUES ("Sloane Stephens", "Venus Williams");
INSERT INTO "matches" VALUES ("Venus Williams", "Coco Gauff");
INSERT INTO "matches" VALUES ("Coco Gauff", "Amanda Anisimova");
INSERT INTO "matches" VALUES ("Amanda Anisimova", "Danielle Collins");
INSERT INTO "matches" VALUES ("Danielle Collins", "Belinda Bencic");
INSERT INTO "matches" VALUES ("Belinda Bencic", "Aryna Sabalenka");
INSERT INTO "players" VALUES ("1", "Serena", "Williams", "right", "1981-09-26");
INSERT INTO "players" VALUES ("2", "Naomi", "Osaka", "right", "1997-10-16");
INSERT INTO "players" VALUES ("3", "Ashleigh", "Barty", "right", "1996-04-24");
INSERT INTO "players" VALUES ("4", "Simona", "Halep", "right", "1991-09-27");
INSERT INTO "players" VALUES ("5", "Petra", "Kvitova", "left", "1990-03-08");
INSERT INTO "players" VALUES ("6", "Karolina", "Pliskova", "right", "1992-03-21");
INSERT INTO "players" VALUES ("7", "Elina", "Svitolina", "right", "1994-09-12");
INSERT INTO "players" VALUES ("8", "Bianca", "Andreescu", "right", "2000-06-16");
INSERT INTO "players" VALUES ("9", "Sofia", "Kenin", "right", "1998-11-14");
INSERT INTO "players" VALUES ("10", "Garbine", "Muguruza", "right", "1993-10-08");
INSERT INTO "players" VALUES ("11", "Victoria", "Azarenka", "right", "1989-07-31");
INSERT INTO "players" VALUES ("12", "Angelique", "Kerber", "left", "1988-01-18");
INSERT INTO "players" VALUES ("13", "Johanna", "Konta", "right", "1991-05-17");
INSERT INTO "players" VALUES ("14", "Madison", "Keys", "right", "1995-02-04");
INSERT INTO "players" VALUES ("15", "Sloane", "Stephens", "right", "1993-03-20");
INSERT INTO "players" VALUES ("16", "Venus", "Williams", "right", "1980-06-17");
INSERT INTO "players" VALUES ("17", "Coco", "Gauff", "right", "2004-03-13");
INSERT INTO "players" VALUES ("18", "Amanda", "Anisimova", "right", "2001-08-31");
INSERT INTO "players" VALUES ("19", "Danielle", "Collins", "right", "1993-12-13");
INSERT INTO "players" VALUES ("20", "Belinda", "Bencic", "right", "1997-03-10");
INSERT INTO "players" VALUES ("21", "Aryna", "Sabalenka", "right", "1998-05-05");
INSERT INTO "players" VALUES ("22", "Monica", "Niculescu", "right", "1987-09-25");
INSERT INTO "players" VALUES ("23", "Barbora", "Strycova", "right", "1986-03-28");
INSERT INTO "players" VALUES ("24", "Carla", "Suarez Navarro", "right", "1988-09-03");
INSERT INTO "players" VALUES ("25", "Julia", "Goerges", "right", "1988-11-02");
INSERT INTO "players" VALUES ("26", "Caroline", "Wozniacki", "right", "1990-07-11");
INSERT INTO "players" VALUES ("27", "Maria", "Sharapova", "right", "1987-04-19");
INSERT INTO "players" VALUES ("28", "Svetlana", "Kuznetsova", "right", "1985-06-27");
INSERT INTO "players" VALUES ("29", "Victoria", "Golubic", "right", "1992-10-16");
INSERT INTO "players" VALUES ("30", "Ajla", "Tomljanovic", "right", "1993-05-07");
INSERT INTO "players" VALUES ("31", "Daria", "Kasatkina", "right", "1997-05-07");
INSERT INTO "players" VALUES ("32", "Veronika", "Kudermetova", "right", "1997-04-24");
INSERT INTO "players" VALUES ("33", "Elena", "Rybakina", "right", "1999-06-17");
INSERT INTO "players" VALUES ("34", "Ons", "Jabeur", "right", "1994-08-28");
INSERT INTO "players" VALUES ("35", "Marketa", "Vondrousova", "left", "1999-06-28");
INSERT INTO "players" VALUES ("36", "Wang", "Qiang", "right", "1992-01-14");
INSERT INTO "players" VALUES ("37", "Zheng", "Saisai", "right", "1994-02-05");
INSERT INTO "players" VALUES ("38", "Alison", "Riske", "right", "1990-07-03");
INSERT INTO "players" VALUES ("39", "Donna", "Vekic", "right", "1996-06-28");
INSERT INTO "players" VALUES ("40", "Dayana", "Yastremska", "right", "2000-05-15");
INSERT INTO "players" VALUES ("41", "Kiki", "Bertens", "right", "1991-12-10");
INSERT INTO "players" VALUES ("42", "Ashlyn", "Krueger", "right", "2004-05-06");
INSERT INTO "players" VALUES ("43", "Leylah", "Fernandez", "left", "2002-09-08");
INSERT INTO "players" VALUES ("44", "Clara", "Tauson", "right", "2002-12-21");
INSERT INTO "players" VALUES ("45", "Emma", "Raducanu", "right", "2002-11-13");
INSERT INTO "players" VALUES ("46", "Iga", "Swiatek", "right", "2001-05-31");
INSERT INTO "players" VALUES ("47", "Jessica", "Pegula", "right", "1994-02-24");
INSERT INTO "players" VALUES ("48", "Maria", "Sakkari", "right", "1995-07-25");
INSERT INTO "players" VALUES ("49", "Ons", "Jabeur", "right", "1994-08-28");
INSERT INTO "players" VALUES ("50", "Caroline", "Garcia", "right", "1993-10-16");
INSERT INTO "players" VALUES ("51", "Beatriz", "Haddad Maia", "left", "1996-05-29");
INSERT INTO "players" VALUES ("52", "Veronika", "Kudermetova", "right", "1997-04-24");
INSERT INTO "players" VALUES ("53", "Liudmila", "Samsonova", "right", "1998-07-30");
INSERT INTO "players" VALUES ("54", "Daria", "Kasatkina", "right", "1997-05-07");
INSERT INTO "players" VALUES ("55", "Belinda", "Bencic", "right", "1997-03-10");
INSERT INTO "players" VALUES ("56", "Victoria", "Azarenka", "right", "1989-07-31");
INSERT INTO "players" VALUES ("57", "Jelena", "Ostapenko", "right", "1997-06-08");
INSERT INTO "players" VALUES ("58", "Barbora", "Krejcikova", "right", "1995-12-18");
INSERT INTO "players" VALUES ("59", "Madison", "Keys", "right", "1995-02-04");
INSERT INTO "players" VALUES ("60", "Petra", "Martic", "right", "1991-01-19");
INSERT INTO "players" VALUES ("61", "Donna", "Vekic", "right", "1996-06-28");
INSERT INTO "players" VALUES ("62", "Elise", "Mertens", "right", "1995-11-17");
INSERT INTO "players" VALUES ("63", "Anastasia", "Potapova", "right", "2001-03-30");
INSERT INTO "players" VALUES ("64", "Qinwen", "Zheng", "right", "2002-10-08");
INSERT INTO "players" VALUES ("65", "Sorana", "Cirstea", "right", "1990-04-07");
INSERT INTO "players" VALUES ("66", "Karolina", "Muchova", "right", "1996-08-21");
INSERT INTO "players" VALUES ("67", "Bernarda", "Pera", "left", "1994-11-03");
INSERT INTO "players" VALUES ("68", "Varvara", "Gracheva", "right", "2000-08-02");
INSERT INTO "players" VALUES ("69", "Linda", "Noskova", "right", "2004-11-17");
INSERT INTO "players" VALUES ("70", "Marie", "Bouzkova", "right", "1998-07-19");
INSERT INTO "players" VALUES ("71", "Shuai", "Zhang", "right", "1989-01-21");
INSERT INTO "players" VALUES ("72", "Ana", "Bogdan", "right", "1992-11-25");
INSERT INTO "players" VALUES ("73", "Mayar", "Sherif", "right", "1996-05-05");
INSERT INTO "players" VALUES ("74", "Tatjana", "Maria", "right", "1987-08-08");
INSERT INTO "players" VALUES ("75", "Alize", "Cornet", "right", "1990-01-22");
INSERT INTO "players" VALUES ("76", "Camila", "Giorgi", "right", "1991-12-30");
INSERT INTO "players" VALUES ("77", "Katerina", "Siniakova", "right", "1996-05-10");
INSERT INTO "players" VALUES ("78", "Danielle", "Collins", "right", "1993-12-13");
INSERT INTO "players" VALUES ("79", "Bianca", "Andreescu", "right", "2000-06-16");
INSERT INTO "players" VALUES ("80", "Sloane", "Stephens", "right", "1993-03-20");
INSERT INTO "players" VALUES ("81", "Victoria", "Tomova", "right", "1995-02-25");
INSERT INTO "players" VALUES ("82", "Anna", "Blinkova", "right", "1998-09-10");
INSERT INTO "players" VALUES ("83", "Rebeka", "Masarova", "right", "1999-08-14");
INSERT INTO "players" VALUES ("84", "Lauren", "Davis", "right", "1993-10-09");
INSERT INTO "players" VALUES ("85", "Alycia", "Parks", "right", "2000-12-31");
INSERT INTO "players" VALUES ("86", "Claire", "Liu", "right", "2000-05-25");
INSERT INTO "players" VALUES ("87", "Xinyu", "Wang", "right", "2001-09-26");
INSERT INTO "players" VALUES ("88", "Yue", "Yuan", "right", "1998-07-05");
INSERT INTO "players" VALUES ("89", "Katie", "Volynets", "right", "2001-12-31");
INSERT INTO "players" VALUES ("90", "Nuria", "Parrizas Diaz", "right", "1991-07-22");
INSERT INTO "players" VALUES ("91", "Anna Karolina", "Schmiedlova", "right", "1994-09-13");
INSERT INTO "players" VALUES ("92", "Dalma", "Galfi", "right", "1998-08-13");
INSERT INTO "players" VALUES ("93", "Cristina", "Bucsa", "right", "1998-01-01");
INSERT INTO "players" VALUES ("94", "Oceane", "Dodin", "right", "1996-10-24");
INSERT INTO "players" VALUES ("95", "Clara", "Burel", "right", "2001-03-26");
INSERT INTO "players" VALUES ("96", "Diane", "Parry", "right", "2002-09-01");
INSERT INTO "players" VALUES ("97", "Leolia", "Jeanjean", "right", "1995-08-15");
INSERT INTO "players" VALUES ("98", "Harmony", "Tan", "right", "1997-09-11");
INSERT INTO "players" VALUES ("99", "Chloe", "Paquet", "right", "1994-07-01");
INSERT INTO "players" VALUES ("100", "Tessah", "Andrianjafitrimo", "right", "1998-10-11");
INSERT INTO "rankings" VALUES ("2023-01-01");
INSERT INTO "rankings" VALUES ("2023-01-08");
INSERT INTO "rankings" VALUES ("2023-01-15");
INSERT INTO "rankings" VALUES ("2023-01-22");
INSERT INTO "rankings" VALUES ("2023-01-29");
INSERT INTO "rankings" VALUES ("2023-02-05");
INSERT INTO "rankings" VALUES ("2023-02-12");
INSERT INTO "rankings" VALUES ("2023-02-19");
INSERT INTO "rankings" VALUES ("2023-02-26");
INSERT INTO "rankings" VALUES ("2023-03-05");