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 "city" (
"ID" INT,
"Population" INT,
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Population" INT,
"LifeExpectancy" FLOAT,
"GovernmentForm" CHAR(45),
"HeadOfState" CHAR(60),
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("ZAF", "Africa", "49000000", "53.0", "Republic", "Jacob Zuma");
INSERT INTO "country" VALUES ("EGY", "Africa", "82000000", "71.0", "Republic", "Abdel Fattah el-Sisi");
INSERT INTO "country" VALUES ("NGA", "Africa", "186000000", "54.0", "Federal Republic", "Muhammadu Buhari");
INSERT INTO "country" VALUES ("KEN", "Africa", "48000000", "63.0", "Republic", "Uhuru Kenyatta");
INSERT INTO "country" VALUES ("MAR", "Africa", "35000000", "76.0", "Constitutional Monarchy", "Mohammed VI");
INSERT INTO "country" VALUES ("DZA", "Africa", "42000000", "77.0", "Republic", "Abdelmadjid Tebboune");
INSERT INTO "country" VALUES ("GHA", "Africa", "30000000", "64.0", "Republic", "Nana Akufo-Addo");
INSERT INTO "country" VALUES ("ETH", "Africa", "112000000", "66.0", "Federal Republic", "Sahle-Work Zewde");
INSERT INTO "country" VALUES ("SDN", "Africa", "43000000", "65.0", "Federal Republic", "Abdalla Hamdok");
INSERT INTO "country" VALUES ("TUN", "Africa", "11000000", "76.0", "Republic", "Kais Saied");
INSERT INTO "country" VALUES ("AGO", "Africa", "32000000", "61.0", "Republic", "João Lourenço");
INSERT INTO "country" VALUES ("CMR", "Africa", "26000000", "59.0", "Republic", "Paul Biya");
INSERT INTO "country" VALUES ("COD", "Africa", "89000000", "60.0", "Republic", "Félix Tshisekedi");
INSERT INTO "country" VALUES ("TZA", "Africa", "59000000", "66.0", "Republic", "Samia Suluhu Hassan");
INSERT INTO "country" VALUES ("UGA", "Africa", "45000000", "63.0", "Republic", "Yoweri Museveni");
INSERT INTO "country" VALUES ("ZMB", "Africa", "18000000", "64.0", "Republic", "Hakainde Hichilema");
INSERT INTO "country" VALUES ("MOZ", "Africa", "31000000", "60.0", "Republic", "Filipe Nyusi");
INSERT INTO "country" VALUES ("MDG", "Africa", "27000000", "66.0", "Republic", "Andry Rajoelina");
INSERT INTO "country" VALUES ("CIV", "Africa", "26000000", "57.0", "Republic", "Alassane Ouattara");
INSERT INTO "country" VALUES ("SEN", "Africa", "16000000", "68.0", "Republic", "Macky Sall");
INSERT INTO "country" VALUES ("GAB", "Africa", "2000000", "69.0", "Republic", "Ali Bongo Ondimba");
INSERT INTO "country" VALUES ("LBY", "Africa", "6000000", "72.0", "Republic", "Mohamed al-Menfi");
INSERT INTO "country" VALUES ("SOM", "Africa", "15000000", "57.0", "Republic", "Hassan Sheikh Mohamud");
INSERT INTO "country" VALUES ("ERI", "Africa", "3000000", "65.0", "Republic", "Isaias Afwerki");
INSERT INTO "country" VALUES ("CAF", "Africa", "5000000", "53.0", "Republic", "Faustin-Archange Touadéra");
INSERT INTO "country" VALUES ("BDI", "Africa", "11000000", "61.0", "Republic", "Évariste Ndayishimiye");
INSERT INTO "country" VALUES ("RWA", "Africa", "12000000", "69.0", "Republic", "Paul Kagame");
INSERT INTO "country" VALUES ("NAM", "Africa", "2000000", "65.0", "Republic", "Hage Geingob");
INSERT INTO "country" VALUES ("BWA", "Africa", "2000000", "69.0", "Republic", "Mokgweetsi Masisi");
INSERT INTO "country" VALUES ("ZWE", "Africa", "15000000", "61.0", "Republic", "Emmerson Mnangagwa");
INSERT INTO "country" VALUES ("MLI", "Africa", "20000000", "59.0", "Republic", "Assimi Goïta");
INSERT INTO "country" VALUES ("NER", "Africa", "24000000", "62.0", "Republic", "Mohamed Bazoum");
INSERT INTO "country" VALUES ("TCD", "Africa", "16000000", "55.0", "Republic", "Mahamat Déby");
INSERT INTO "country" VALUES ("BEN", "Africa", "12000000", "61.0", "Republic", "Patrice Talon");
INSERT INTO "country" VALUES ("TGO", "Africa", "8000000", "61.0", "Republic", "Faure Gnassingbé");
INSERT INTO "country" VALUES ("BFA", "Africa", "21000000", "61.0", "Republic", "Ibrahim Traoré");
INSERT INTO "country" VALUES ("SLE", "Africa", "8000000", "55.0", "Republic", "Julius Maada Bio");
INSERT INTO "country" VALUES ("LBR", "Africa", "5000000", "64.0", "Republic", "George Weah");
INSERT INTO "country" VALUES ("GIN", "Africa", "13000000", "61.0", "Republic", "Mamady Doumbouya");
INSERT INTO "country" VALUES ("GMB", "Africa", "2000000", "62.0", "Republic", "Adama Barrow");
INSERT INTO "country" VALUES ("GNB", "Africa", "2000000", "59.0", "Republic", "Umaro Sissoco Embaló");
INSERT INTO "country" VALUES ("CPV", "Africa", "500000", "74.0", "Republic", "José Maria Neves");
INSERT INTO "country" VALUES ("COM", "Africa", "800000", "64.0", "Federal Republic", "Azali Assoumani");
INSERT INTO "country" VALUES ("MUS", "Africa", "1000000", "75.0", "Republic", "Prithvirajsing Roopun");
INSERT INTO "country" VALUES ("SYC", "Africa", "100000", "73.0", "Republic", "Wavel Ramkalawan");
INSERT INTO "country" VALUES ("STP", "Africa", "200000", "70.0", "Republic", "Carlos Vila Nova");
INSERT INTO "country" VALUES ("GNQ", "Africa", "1000000", "59.0", "Republic", "Teodoro Obiang Nguema Mbasogo");
INSERT INTO "country" VALUES ("COG", "Africa", "5000000", "65.0", "Republic", "Denis Sassou Nguesso");
INSERT INTO "country" VALUES ("SWZ", "Africa", "1000000", "58.0", "Absolute Monarchy", "Mswati III");
INSERT INTO "country" VALUES ("LSO", "Africa", "2000000", "54.0", "Constitutional Monarchy", "Letsie III");
INSERT INTO "country" VALUES ("MRT", "Africa", "4000000", "64.0", "Republic", "Mohamed Ould Ghazouani");
INSERT INTO "country" VALUES ("DJI", "Africa", "1000000", "67.0", "Republic", "Ismaïl Omar Guelleh");
INSERT INTO "country" VALUES ("SSD", "Africa", "11000000", "57.0", "Republic", "Salva Kiir Mayardit");
INSERT INTO "country" VALUES ("SOM_MON", "Africa", "1000000", "50.0", "Monarchy", "King X");
INSERT INTO "country" VALUES ("SOM_FED", "Africa", "1000000", "55.0", "Federal Republic", "President Y");
INSERT INTO "country" VALUES ("SOM_REP", "Africa", "1000000", "60.0", "Republic", "President Z");
INSERT INTO "country" VALUES ("FRA", "Europe", "67000000", "82.0", "Republic", "Emmanuel Macron");
INSERT INTO "country" VALUES ("DEU", "Europe", "83000000", "81.0", "Federal Republic", "Frank-Walter Steinmeier");
INSERT INTO "country" VALUES ("USA", "North America", "330000000", "79.0", "Federal Republic", "Joe Biden");
INSERT INTO "country" VALUES ("CAN", "North America", "38000000", "82.0", "Constitutional Monarchy", "Justin Trudeau");
INSERT INTO "country" VALUES ("AUS", "Oceania", "26000000", "83.0", "Constitutional Monarchy", "Anthony Albanese");
INSERT INTO "country" VALUES ("JPN", "Asia", "125000000", "84.0", "Constitutional Monarchy", "Naruhito");
INSERT INTO "country" VALUES ("CHN", "Asia", "1400000000", "77.0", "Peoples Republic", "Xi Jinping");
INSERT INTO "country" VALUES ("IND", "Asia", "1380000000", "70.0", "Federal Republic", "Droupadi Murmu");
INSERT INTO "country" VALUES ("BRA", "South America", "215000000", "76.0", "Federal Republic", "Luiz Inácio Lula da Silva");
INSERT INTO "country" VALUES ("ARG", "South America", "45000000", "77.0", "Federal Republic", "Javier Milei");