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 "constructors" (
"constructorId" INT,
"nationality" TEXT,
PRIMARY KEY ("constructorId")
);

CREATE TABLE "drivers" (
"driverId" INT,
"forename" TEXT,
"surname" TEXT,
"dob" DATE,
"nationality" TEXT,
PRIMARY KEY ("driverId")
);

CREATE TABLE "races" (
"raceId" INT,
"year" INT,
PRIMARY KEY ("raceId")
);



INSERT INTO "constructors" VALUES ("1", "British");
INSERT INTO "constructors" VALUES ("2", "German");
INSERT INTO "constructors" VALUES ("3", "Italian");
INSERT INTO "constructors" VALUES ("4", "French");
INSERT INTO "constructors" VALUES ("5", "American");
INSERT INTO "drivers" VALUES ("1", "Lewis", "Hamilton", "1985-01-07", "British");
INSERT INTO "drivers" VALUES ("2", "Jenson", "Button", "1980-01-19", "British");
INSERT INTO "drivers" VALUES ("3", "Sebastian", "Vettel", "1987-07-03", "German");
INSERT INTO "drivers" VALUES ("4", "Fernando", "Alonso", "1981-07-29", "Spanish");
INSERT INTO "drivers" VALUES ("5", "Kimi", "Raikkonen", "1979-10-17", "Finnish");
INSERT INTO "drivers" VALUES ("6", "George", "Russell", "1998-02-15", "British");
INSERT INTO "drivers" VALUES ("7", "Lando", "Norris", "1999-11-13", "British");
INSERT INTO "drivers" VALUES ("8", "Max", "Verstappen", "1997-09-30", "Dutch");
INSERT INTO "drivers" VALUES ("9", "Daniel", "Ricciardo", "1989-07-01", "Australian");
INSERT INTO "drivers" VALUES ("10", "Nico", "Rosberg", "1985-06-27", "German");
INSERT INTO "drivers" VALUES ("11", "Mark", "Webber", "1976-08-27", "Australian");
INSERT INTO "drivers" VALUES ("12", "David", "Coulthard", "1971-03-27", "British");
INSERT INTO "drivers" VALUES ("13", "Damon", "Hill", "1960-09-17", "British");
INSERT INTO "drivers" VALUES ("14", "Nigel", "Mansell", "1953-08-08", "British");
INSERT INTO "drivers" VALUES ("15", "James", "Hunt", "1947-08-29", "British");
INSERT INTO "drivers" VALUES ("16", "Jackie", "Stewart", "1939-06-11", "British");
INSERT INTO "drivers" VALUES ("17", "Graham", "Hill", "1929-02-15", "British");
INSERT INTO "drivers" VALUES ("18", "Jim", "Clark", "1936-03-04", "British");
INSERT INTO "drivers" VALUES ("19", "Stirling", "Moss", "1929-09-17", "British");
INSERT INTO "drivers" VALUES ("20", "John", "Surtees", "1934-02-11", "British");
INSERT INTO "drivers" VALUES ("21", "Jack", "Brabham", "1926-04-02", "Australian");
INSERT INTO "drivers" VALUES ("22", "Alan", "Jones", "1946-11-02", "Australian");
INSERT INTO "drivers" VALUES ("23", "Nelson", "Piquet", "1952-08-07", "Brazilian");
INSERT INTO "drivers" VALUES ("24", "Alain", "Prost", "1955-02-24", "French");
INSERT INTO "drivers" VALUES ("25", "Ayrton", "Senna", "1960-03-21", "Brazilian");
INSERT INTO "drivers" VALUES ("26", "Michael", "Schumacher", "1969-01-03", "German");
INSERT INTO "drivers" VALUES ("27", "Rubens", "Barrichello", "1972-05-23", "Brazilian");
INSERT INTO "drivers" VALUES ("28", "Juan Pablo", "Montoya", "1975-09-20", "Colombian");
INSERT INTO "drivers" VALUES ("29", "Felipe", "Massa", "1981-04-25", "Brazilian");
INSERT INTO "drivers" VALUES ("30", "Robert", "Kubica", "1984-12-07", "Polish");
INSERT INTO "drivers" VALUES ("31", "Kamui", "Kobayashi", "1986-09-13", "Japanese");
INSERT INTO "drivers" VALUES ("32", "Romain", "Grosjean", "1986-04-17", "French");
INSERT INTO "drivers" VALUES ("33", "Valtteri", "Bottas", "1989-08-28", "Finnish");
INSERT INTO "drivers" VALUES ("34", "Sergio", "Perez", "1990-01-26", "Mexican");
INSERT INTO "drivers" VALUES ("35", "Carlos", "Sainz Jr.", "1994-09-01", "Spanish");
INSERT INTO "drivers" VALUES ("36", "Charles", "Leclerc", "1997-10-16", "Monegasque");
INSERT INTO "drivers" VALUES ("37", "Esteban", "Ocon", "1996-09-17", "French");
INSERT INTO "drivers" VALUES ("38", "Pierre", "Gasly", "1996-02-07", "French");
INSERT INTO "drivers" VALUES ("39", "Alexander", "Albon", "1996-03-23", "Thai");
INSERT INTO "drivers" VALUES ("40", "Nicholas", "Latifi", "1995-06-29", "Canadian");
INSERT INTO "drivers" VALUES ("41", "Mick", "Schumacher", "1999-03-22", "German");
INSERT INTO "drivers" VALUES ("42", "Yuki", "Tsunoda", "2000-05-11", "Japanese");
INSERT INTO "drivers" VALUES ("43", "Guanyu", "Zhou", "1999-05-30", "Chinese");
INSERT INTO "drivers" VALUES ("44", "Oscar", "Piastri", "2001-04-06", "Australian");
INSERT INTO "drivers" VALUES ("45", "Logan", "Sargeant", "2000-12-31", "American");
INSERT INTO "drivers" VALUES ("46", "Jack", "Doohan", "2003-01-20", "Australian");
INSERT INTO "drivers" VALUES ("47", "Oliver", "Bearman", "2005-05-08", "British");
INSERT INTO "drivers" VALUES ("48", "Andrea", "Dovizioso", "1986-03-23", "Italian");
INSERT INTO "drivers" VALUES ("49", "Cal", "Crutchlow", "1985-10-29", "British");
INSERT INTO "drivers" VALUES ("50", "Scott", "Redding", "1993-01-04", "British");
INSERT INTO "drivers" VALUES ("51", "Bradley", "Smith", "1990-11-28", "British");
INSERT INTO "drivers" VALUES ("52", "Sam", "Lowes", "1990-09-14", "British");
INSERT INTO "drivers" VALUES ("53", "Jake", "Dixon", "1995-01-15", "British");
INSERT INTO "drivers" VALUES ("54", "John", "McPhee", "1994-07-14", "British");
INSERT INTO "drivers" VALUES ("55", "Danny", "Kent", "1993-11-25", "British");
INSERT INTO "drivers" VALUES ("56", "Jonas", "Folger", "1993-08-14", "German");
INSERT INTO "drivers" VALUES ("57", "Johann", "Zarco", "1990-07-16", "French");
INSERT INTO "drivers" VALUES ("58", "Fabio", "Quartararo", "1999-04-20", "French");
INSERT INTO "drivers" VALUES ("59", "Francesco", "Bagnaia", "1997-01-14", "Italian");
INSERT INTO "drivers" VALUES ("60", "Enea", "Bastianini", "1997-12-30", "Italian");
INSERT INTO "drivers" VALUES ("61", "Marc", "Marquez", "1993-02-17", "Spanish");
INSERT INTO "drivers" VALUES ("62", "Pol", "Espargaro", "1991-06-10", "Spanish");
INSERT INTO "drivers" VALUES ("63", "Alex", "Rins", "1995-12-08", "Spanish");
INSERT INTO "drivers" VALUES ("64", "Joan", "Mir", "1997-09-01", "Spanish");
INSERT INTO "drivers" VALUES ("65", "Miguel", "Oliveira", "1995-01-04", "Portuguese");
INSERT INTO "drivers" VALUES ("66", "Brad", "Binder", "1995-08-11", "South African");
INSERT INTO "drivers" VALUES ("67", "Jack", "Miller", "1995-01-18", "Australian");
INSERT INTO "drivers" VALUES ("68", "Franco", "Morbidelli", "1994-01-23", "Italian");
INSERT INTO "drivers" VALUES ("69", "Takaaki", "Nakagami", "1992-02-09", "Japanese");
INSERT INTO "drivers" VALUES ("70", "Aleix", "Espargaro", "1989-07-30", "Spanish");
INSERT INTO "drivers" VALUES ("71", "Maverick", "Vinales", "1995-01-12", "Spanish");
INSERT INTO "drivers" VALUES ("72", "Jorge", "Martin", "1998-01-29", "Spanish");
INSERT INTO "drivers" VALUES ("73", "Luca", "Marini", "1997-08-10", "Italian");
INSERT INTO "drivers" VALUES ("74", "Marco", "Bezzecchi", "1998-11-12", "Italian");
INSERT INTO "drivers" VALUES ("75", "Augusto", "Fernandez", "2000-09-23", "Spanish");
INSERT INTO "drivers" VALUES ("76", "Raul", "Fernandez", "2000-10-23", "Spanish");
INSERT INTO "drivers" VALUES ("77", "Pedro", "Acosta", "2004-05-25", "Spanish");
INSERT INTO "drivers" VALUES ("78", "Celestino", "Vietti", "2001-10-13", "Italian");
INSERT INTO "drivers" VALUES ("79", "Tony", "Arbolino", "2000-08-03", "Italian");
INSERT INTO "drivers" VALUES ("80", "Ai", "Ogura", "2001-01-26", "Japanese");
INSERT INTO "drivers" VALUES ("81", "Somkiat", "Chantra", "1998-12-15", "Thai");
INSERT INTO "drivers" VALUES ("82", "Arbolino", "Tony", "2000-08-03", "Italian");
INSERT INTO "drivers" VALUES ("83", "Darryn", "Binder", "1998-01-21", "South African");
INSERT INTO "drivers" VALUES ("84", "Remy", "Gardner", "1998-02-24", "Australian");
INSERT INTO "drivers" VALUES ("85", "Raul", "Fernandez", "2000-10-23", "Spanish");
INSERT INTO "drivers" VALUES ("86", "Fabio", "Di Giannantonio", "1998-10-10", "Italian");
INSERT INTO "drivers" VALUES ("87", "Lorenzo", "Dalla Porta", "1997-06-13", "Italian");
INSERT INTO "drivers" VALUES ("88", "Niccolo", "Antonelli", "1995-02-23", "Italian");
INSERT INTO "drivers" VALUES ("89", "Gabriel", "Rodrigo", "1996-10-21", "Argentine");
INSERT INTO "drivers" VALUES ("90", "Dennis", "Foggia", "2001-01-07", "Italian");
INSERT INTO "drivers" VALUES ("91", "Jaume", "Masia", "2000-10-25", "Spanish");
INSERT INTO "drivers" VALUES ("92", "Sergio", "Garcia", "2003-03-22", "Spanish");
INSERT INTO "drivers" VALUES ("93", "Izan", "Guevara", "2004-06-28", "Spanish");
INSERT INTO "drivers" VALUES ("94", "Deniz", "Oncu", "2003-07-26", "Turkish");
INSERT INTO "drivers" VALUES ("95", "Ayumu", "Sasaki", "2000-10-04", "Japanese");
INSERT INTO "drivers" VALUES ("96", "Ryusei", "Yamanaka", "2001-09-17", "Japanese");
INSERT INTO "drivers" VALUES ("97", "Kaito", "Toba", "2000-04-13", "Japanese");
INSERT INTO "drivers" VALUES ("98", "Tatsuki", "Suzuki", "1997-09-24", "Japanese");
INSERT INTO "drivers" VALUES ("99", "Andrea", "Migno", "1996-01-10", "Italian");
INSERT INTO "drivers" VALUES ("100", "Riccardo", "Rossi", "2000-03-22", "Italian");
INSERT INTO "drivers" VALUES ("101", "Scott", "Deroue", "1995-09-23", "Dutch");
INSERT INTO "drivers" VALUES ("102", "Darryn", "Binder", "1998-01-21", "South African");
INSERT INTO "drivers" VALUES ("103", "John", "McPhee", "1994-07-14", "British");
INSERT INTO "drivers" VALUES ("104", "Gabriel", "Rodrigo", "1996-10-21", "Argentine");
INSERT INTO "drivers" VALUES ("105", "Dennis", "Foggia", "2001-01-07", "Italian");
INSERT INTO "drivers" VALUES ("106", "Jaume", "Masia", "2000-10-25", "Spanish");
INSERT INTO "drivers" VALUES ("107", "Sergio", "Garcia", "2003-03-22", "Spanish");
INSERT INTO "drivers" VALUES ("108", "Izan", "Guevara", "2004-06-28", "Spanish");
INSERT INTO "drivers" VALUES ("109", "Deniz", "Oncu", "2003-07-26", "Turkish");
INSERT INTO "drivers" VALUES ("110", "Ayumu", "Sasaki", "2000-10-04", "Japanese");
INSERT INTO "drivers" VALUES ("111", "Ryusei", "Yamanaka", "2001-09-17", "Japanese");
INSERT INTO "drivers" VALUES ("112", "Kaito", "Toba", "2000-04-13", "Japanese");
INSERT INTO "drivers" VALUES ("113", "Tatsuki", "Suzuki", "1997-09-24", "Japanese");
INSERT INTO "drivers" VALUES ("114", "Andrea", "Migno", "1996-01-10", "Italian");
INSERT INTO "drivers" VALUES ("115", "Riccardo", "Rossi", "2000-03-22", "Italian");
INSERT INTO "drivers" VALUES ("116", "Scott", "Deroue", "1995-09-23", "Dutch");
INSERT INTO "drivers" VALUES ("117", "Jenson", "Button", "1980-01-19", "British");
INSERT INTO "drivers" VALUES ("118", "Gary", "Paffett", "1981-08-11", "British");
INSERT INTO "drivers" VALUES ("119", "Anthony", "Davidson", "1980-04-18", "British");
INSERT INTO "drivers" VALUES ("120", "Paul", "Di Resta", "1986-04-16", "British");
INSERT INTO "drivers" VALUES ("121", "Will", "Stevens", "1991-06-28", "British");
INSERT INTO "drivers" VALUES ("122", "Max", "Chilton", "1991-04-21", "British");
INSERT INTO "drivers" VALUES ("123", "Oliver", "Turvey", "1987-04-19", "British");
INSERT INTO "drivers" VALUES ("124", "Sam", "Bird", "1987-01-09", "British");
INSERT INTO "drivers" VALUES ("125", "Alex", "Lynn", "1993-09-17", "British");
INSERT INTO "drivers" VALUES ("126", "Jake", "Dennis", "1995-08-16", "British");
INSERT INTO "drivers" VALUES ("127", "Dan", "Ticktum", "1999-06-08", "British");
INSERT INTO "drivers" VALUES ("128", "Callum", "Ilott", "1998-11-11", "British");
INSERT INTO "drivers" VALUES ("129", "Christian", "Lundgaard", "2001-07-23", "Danish");
INSERT INTO "drivers" VALUES ("130", "Frederik", "Vesti", "2002-01-13", "Danish");
INSERT INTO "drivers" VALUES ("131", "Liam", "Lawson", "2002-02-11", "New Zealander");
INSERT INTO "drivers" VALUES ("132", "Dennis", "Hauger", "2003-03-17", "Norwegian");
INSERT INTO "drivers" VALUES ("133", "Arthur", "Leclerc", "2000-10-14", "Monegasque");
INSERT INTO "drivers" VALUES ("134", "Théo", "Pourchaire", "2003-08-20", "French");
INSERT INTO "drivers" VALUES ("135", "Victor", "Martins", "2001-06-16", "French");
INSERT INTO "drivers" VALUES ("136", "Isack", "Hadjar", "2004-09-28", "French");
INSERT INTO "drivers" VALUES ("137", "Zane", "Maloney", "2003-10-02", "Barbadian");
INSERT INTO "drivers" VALUES ("138", "Oliver", "Bearman", "2005-05-08", "British");
INSERT INTO "drivers" VALUES ("139", "Franco", "Colapinto", "2003-05-27", "Argentine");
INSERT INTO "drivers" VALUES ("140", "Gabriel", "Bortoleto", "2004-10-14", "Brazilian");
INSERT INTO "drivers" VALUES ("141", "Andrea", "Kimi Antonelli", "2006-08-25", "Italian");
INSERT INTO "drivers" VALUES ("142", "Arvid", "Lindblad", "2007-08-08", "British");
INSERT INTO "drivers" VALUES ("143", "Ugo", "Ugochukwu", "2007-06-23", "American");
INSERT INTO "drivers" VALUES ("144", "Tuukka", "Taponen", "2006-10-26", "Finnish");
INSERT INTO "drivers" VALUES ("145", "Nikola", "Tsolov", "2006-12-21", "Bulgarian");
INSERT INTO "drivers" VALUES ("146", "Alex", "Dunne", "2005-11-29", "Irish");
INSERT INTO "drivers" VALUES ("147", "Taylor", "Barnard", "2005-06-01", "British");
INSERT INTO "drivers" VALUES ("148", "Zak", "O'Sullivan", "2005-02-06", "British");
INSERT INTO "drivers" VALUES ("149", "Luke", "Browning", "2005-02-10", "British");
INSERT INTO "drivers" VALUES ("150", "Joseph", "Loake", "2005-08-14", "British");
INSERT INTO "drivers" VALUES ("151", "Louis", "Sharp", "2005-09-14", "British");
INSERT INTO "drivers" VALUES ("152", "Jenson", "Button", "1980-01-19", "British");
INSERT INTO "drivers" VALUES ("153", "Anthony", "Davidson", "1980-04-18", "British");
INSERT INTO "drivers" VALUES ("154", "Gary", "Paffett", "1980-08-11", "British");
INSERT INTO "drivers" VALUES ("155", "Darren", "Turner", "1974-04-13", "British");
INSERT INTO "drivers" VALUES ("156", "Allan", "McNish", "1969-12-29", "British");
INSERT INTO "drivers" VALUES ("157", "Johnny", "Herbert", "1964-06-25", "British");
INSERT INTO "drivers" VALUES ("158", "Martin", "Brundle", "1959-06-01", "British");
INSERT INTO "drivers" VALUES ("159", "Derek", "Warwick", "1954-08-27", "British");
INSERT INTO "drivers" VALUES ("160", "Nigel", "Mansell", "1953-08-08", "British");
INSERT INTO "drivers" VALUES ("161", "John", "Watson", "1946-05-23", "British");
INSERT INTO "drivers" VALUES ("162", "James", "Hunt", "1947-08-29", "British");
INSERT INTO "drivers" VALUES ("163", "Jackie", "Stewart", "1939-06-11", "British");
INSERT INTO "drivers" VALUES ("164", "Graham", "Hill", "1929-02-15", "British");
INSERT INTO "drivers" VALUES ("165", "Jim", "Clark", "1936-03-04", "British");
INSERT INTO "drivers" VALUES ("166", "Stirling", "Moss", "1929-09-17", "British");
INSERT INTO "drivers" VALUES ("167", "John", "Surtees", "1934-02-11", "British");
INSERT INTO "drivers" VALUES ("168", "Mike", "Hawthorn", "1929-04-10", "British");
INSERT INTO "drivers" VALUES ("169", "Peter", "Collins", "1931-11-06", "British");
INSERT INTO "drivers" VALUES ("170", "Tony", "Brooks", "1932-02-25", "British");
INSERT INTO "drivers" VALUES ("171", "Roy", "Salvadori", "1922-05-12", "British");
INSERT INTO "drivers" VALUES ("172", "Jack", "Fairman", "1913-03-15", "British");
INSERT INTO "drivers" VALUES ("173", "Innes", "Ireland", "1930-06-12", "British");
INSERT INTO "drivers" VALUES ("174", "Cliff", "Allison", "1936-02-08", "British");