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),
"Population" INT,
"LifeExpectancy" FLOAT,
"GNP" FLOAT,
"GovernmentForm" CHAR(45),
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
"Percentage" FLOAT,
PRIMARY KEY ("CountryCode", "Language")
);





INSERT INTO "city" VALUES ("1", "100000");
INSERT INTO "city" VALUES ("2", "250000");
INSERT INTO "city" VALUES ("3", "500000");
INSERT INTO "city" VALUES ("4", "1000000");
INSERT INTO "city" VALUES ("5", "50000");
INSERT INTO "city" VALUES ("6", "750000");
INSERT INTO "city" VALUES ("7", "1200000");
INSERT INTO "city" VALUES ("8", "300000");
INSERT INTO "city" VALUES ("9", "900000");
INSERT INTO "city" VALUES ("10", "150000");
INSERT INTO "country" VALUES ("USA", "330000000", "78.5", "21000000.0", "Federal Republic");
INSERT INTO "country" VALUES ("CAN", "38000000", "82.0", "1700000.0", "Federal parliamentary democracy");
INSERT INTO "country" VALUES ("GBR", "67000000", "81.0", "2800000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("FRA", "65000000", "82.5", "2700000.0", "Republic");
INSERT INTO "country" VALUES ("DEU", "83000000", "81.0", "3800000.0", "Federal Republic");
INSERT INTO "country" VALUES ("JPN", "126000000", "84.0", "5000000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("CHN", "1400000000", "77.0", "14000000.0", "Peoples Republic");
INSERT INTO "country" VALUES ("IND", "1380000000", "69.0", "2900000.0", "Federal Republic");
INSERT INTO "country" VALUES ("BRA", "212000000", "75.0", "1800000.0", "Federal Republic");
INSERT INTO "country" VALUES ("MEX", "128000000", "75.0", "1200000.0", "Federal Republic");
INSERT INTO "country" VALUES ("RUS", "145000000", "73.0", "1600000.0", "Federal Republic");
INSERT INTO "country" VALUES ("ZAF", "59000000", "64.0", "350000.0", "Republic");
INSERT INTO "country" VALUES ("EGY", "102000000", "72.0", "300000.0", "Republic");
INSERT INTO "country" VALUES ("NGA", "206000000", "55.0", "450000.0", "Federal Republic");
INSERT INTO "country" VALUES ("AUS", "25000000", "83.0", "1400000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("NZL", "5000000", "82.0", "200000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("SWE", "10000000", "82.0", "500000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("NOR", "5000000", "82.0", "450000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("FIN", "5000000", "82.0", "280000.0", "Republic");
INSERT INTO "country" VALUES ("DNK", "5000000", "81.0", "350000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("CHE", "8000000", "83.0", "700000.0", "Federal Republic");
INSERT INTO "country" VALUES ("AUT", "9000000", "81.0", "450000.0", "Federal Republic");
INSERT INTO "country" VALUES ("BEL", "11000000", "81.0", "550000.0", "Federal Monarchy");
INSERT INTO "country" VALUES ("NLD", "17000000", "81.0", "900000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("ESP", "47000000", "83.0", "1400000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("ITA", "60000000", "83.0", "2000000.0", "Republic");
INSERT INTO "country" VALUES ("GRC", "10000000", "81.0", "200000.0", "Republic");
INSERT INTO "country" VALUES ("PRT", "10000000", "82.0", "250000.0", "Republic");
INSERT INTO "country" VALUES ("IRL", "5000000", "82.0", "400000.0", "Republic");
INSERT INTO "country" VALUES ("POL", "38000000", "78.0", "600000.0", "Republic");
INSERT INTO "country" VALUES ("UKR", "44000000", "72.0", "150000.0", "Republic");
INSERT INTO "country" VALUES ("ROU", "19000000", "76.0", "250000.0", "Republic");
INSERT INTO "country" VALUES ("HUN", "9000000", "76.0", "180000.0", "Republic");
INSERT INTO "country" VALUES ("CZE", "10000000", "79.0", "280000.0", "Republic");
INSERT INTO "country" VALUES ("SVK", "5000000", "77.0", "120000.0", "Republic");
INSERT INTO "country" VALUES ("SGP", "5000000", "83.0", "350000.0", "Republic");
INSERT INTO "country" VALUES ("KOR", "51000000", "83.0", "1600000.0", "Republic");
INSERT INTO "country" VALUES ("THA", "69000000", "77.0", "500000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("VNM", "97000000", "75.0", "270000.0", "Socialist Republic");
INSERT INTO "country" VALUES ("IDN", "270000000", "71.0", "1100000.0", "Republic");
INSERT INTO "country" VALUES ("PHL", "109000000", "71.0", "370000.0", "Republic");
INSERT INTO "country" VALUES ("MYS", "32000000", "76.0", "360000.0", "Federal Constitutional Monarchy");
INSERT INTO "country" VALUES ("SAU", "34000000", "75.0", "700000.0", "Monarchy");
INSERT INTO "country" VALUES ("ARE", "9000000", "78.0", "400000.0", "Federal Monarchy");
INSERT INTO "country" VALUES ("ISR", "9000000", "83.0", "400000.0", "Parliamentary Republic");
INSERT INTO "country" VALUES ("TUR", "84000000", "78.0", "750000.0", "Republic");
INSERT INTO "country" VALUES ("ARG", "45000000", "76.0", "450000.0", "Federal Republic");
INSERT INTO "country" VALUES ("CHL", "19000000", "80.0", "300000.0", "Republic");
INSERT INTO "country" VALUES ("COL", "50000000", "77.0", "300000.0", "Republic");
INSERT INTO "country" VALUES ("PER", "32000000", "76.0", "200000.0", "Republic");
INSERT INTO "country" VALUES ("VEN", "28000000", "72.0", "100000.0", "Federal Republic");
INSERT INTO "country" VALUES ("ECU", "17000000", "77.0", "100000.0", "Republic");
INSERT INTO "country" VALUES ("BOL", "11000000", "71.0", "40000.0", "Republic");
INSERT INTO "country" VALUES ("PRY", "7000000", "74.0", "40000.0", "Republic");
INSERT INTO "country" VALUES ("URY", "3000000", "78.0", "60000.0", "Republic");
INSERT INTO "country" VALUES ("CUB", "11000000", "79.0", "100000.0", "Socialist Republic");
INSERT INTO "country" VALUES ("DOM", "10000000", "74.0", "90000.0", "Republic");
INSERT INTO "country" VALUES ("HTI", "11000000", "64.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("JAM", "2000000", "76.0", "15000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("CRI", "5000000", "80.0", "60000.0", "Republic");
INSERT INTO "country" VALUES ("PAN", "4000000", "79.0", "60000.0", "Republic");
INSERT INTO "country" VALUES ("GTM", "17000000", "74.0", "80000.0", "Republic");
INSERT INTO "country" VALUES ("HND", "9000000", "75.0", "25000.0", "Republic");
INSERT INTO "country" VALUES ("SLV", "6000000", "75.0", "27000.0", "Republic");
INSERT INTO "country" VALUES ("NIC", "6000000", "74.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("BHS", "400000", "74.0", "12000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("BRB", "300000", "76.0", "5000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("TTO", "1000000", "73.0", "25000.0", "Republic");
INSERT INTO "country" VALUES ("GUY", "800000", "70.0", "5000.0", "Republic");
INSERT INTO "country" VALUES ("SUR", "600000", "72.0", "5000.0", "Republic");
INSERT INTO "country" VALUES ("GUF", "300000", "77.0", "2000.0", "Overseas Department of France");
INSERT INTO "country" VALUES ("MLI", "20000000", "59.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("NGA", "206000000", "55.0", "450000.0", "Federal Republic");
INSERT INTO "country" VALUES ("ETH", "115000000", "66.0", "90000.0", "Federal Republic");
INSERT INTO "country" VALUES ("KEN", "53000000", "66.0", "100000.0", "Republic");
INSERT INTO "country" VALUES ("TZA", "60000000", "65.0", "60000.0", "Republic");
INSERT INTO "country" VALUES ("UGA", "45000000", "63.0", "30000.0", "Republic");
INSERT INTO "country" VALUES ("SDN", "43000000", "65.0", "30000.0", "Federal Republic");
INSERT INTO "country" VALUES ("DZA", "44000000", "77.0", "170000.0", "Republic");
INSERT INTO "country" VALUES ("MAR", "36000000", "77.0", "120000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("TUN", "11000000", "76.0", "40000.0", "Republic");
INSERT INTO "country" VALUES ("LBY", "6000000", "72.0", "50000.0", "Transitional Government");
INSERT INTO "country" VALUES ("SOM", "15000000", "57.0", "5000.0", "Federal Republic");
INSERT INTO "country" VALUES ("ERI", "3000000", "65.0", "2000.0", "Republic");
INSERT INTO "country" VALUES ("DJI", "1000000", "62.0", "3000.0", "Republic");
INSERT INTO "country" VALUES ("SSD", "11000000", "58.0", "5000.0", "Republic");
INSERT INTO "country" VALUES ("CAF", "5000000", "53.0", "2000.0", "Republic");
INSERT INTO "country" VALUES ("COD", "89000000", "60.0", "50000.0", "Republic");
INSERT INTO "country" VALUES ("COG", "5000000", "65.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("GAB", "2000000", "67.0", "20000.0", "Republic");
INSERT INTO "country" VALUES ("CMR", "26000000", "59.0", "40000.0", "Republic");
INSERT INTO "country" VALUES ("NIG", "24000000", "62.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("TCD", "16000000", "55.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("BFA", "21000000", "61.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("MLI", "20000000", "59.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("MRT", "4000000", "64.0", "5000.0", "Republic");
INSERT INTO "country" VALUES ("SEN", "16000000", "68.0", "25000.0", "Republic");
INSERT INTO "country" VALUES ("GMB", "2000000", "62.0", "2000.0", "Republic");
INSERT INTO "country" VALUES ("GIN", "13000000", "61.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("GNB", "2000000", "58.0", "2000.0", "Republic");
INSERT INTO "country" VALUES ("SLE", "8000000", "55.0", "4000.0", "Republic");
INSERT INTO "country" VALUES ("LBR", "5000000", "64.0", "3000.0", "Republic");
INSERT INTO "country" VALUES ("CIV", "26000000", "58.0", "50000.0", "Republic");
INSERT INTO "country" VALUES ("GHA", "31000000", "64.0", "60000.0", "Republic");
INSERT INTO "country" VALUES ("TGO", "8000000", "61.0", "5000.0", "Republic");
INSERT INTO "country" VALUES ("BEN", "12000000", "61.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("BWA", "2000000", "69.0", "20000.0", "Republic");
INSERT INTO "country" VALUES ("NAM", "2000000", "65.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("ZMB", "18000000", "64.0", "25000.0", "Republic");
INSERT INTO "country" VALUES ("ZWE", "15000000", "61.0", "20000.0", "Republic");
INSERT INTO "country" VALUES ("MOZ", "31000000", "61.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("MDG", "27000000", "66.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("MWI", "19000000", "64.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("LSO", "2000000", "54.0", "2000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("SWZ", "1000000", "58.0", "5000.0", "Absolute Monarchy");
INSERT INTO "country" VALUES ("COM", "800000", "64.0", "1000.0", "Federal Republic");
INSERT INTO "country" VALUES ("MUS", "1000000", "75.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("SYC", "100000", "73.0", "2000.0", "Republic");
INSERT INTO "country" VALUES ("MDV", "500000", "79.0", "5000.0", "Republic");
INSERT INTO "country" VALUES ("LKA", "21000000", "76.0", "80000.0", "Republic");
INSERT INTO "country" VALUES ("BGD", "164000000", "72.0", "300000.0", "Republic");
INSERT INTO "country" VALUES ("PAK", "220000000", "67.0", "300000.0", "Federal Republic");
INSERT INTO "country" VALUES ("AFG", "38000000", "64.0", "20000.0", "Islamic Republic");
INSERT INTO "country" VALUES ("IRN", "83000000", "76.0", "450000.0", "Islamic Republic");
INSERT INTO "country" VALUES ("IRQ", "40000000", "71.0", "200000.0", "Parliamentary Republic");
INSERT INTO "country" VALUES ("SYR", "17000000", "71.0", "50000.0", "Republic");
INSERT INTO "country" VALUES ("JOR", "10000000", "75.0", "40000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("LBN", "6000000", "79.0", "50000.0", "Republic");
INSERT INTO "country" VALUES ("KWT", "4000000", "75.0", "150000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("BHR", "1000000", "77.0", "40000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("QAT", "2000000", "79.0", "180000.0", "Monarchy");
INSERT INTO "country" VALUES ("OMN", "5000000", "77.0", "80000.0", "Monarchy");
INSERT INTO "country" VALUES ("YEM", "29000000", "66.0", "20000.0", "Republic");
INSERT INTO "country" VALUES ("GEO", "3000000", "74.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("ARM", "3000000", "75.0", "12000.0", "Republic");
INSERT INTO "country" VALUES ("AZE", "10000000", "73.0", "50000.0", "Republic");
INSERT INTO "country" VALUES ("KAZ", "18000000", "73.0", "180000.0", "Republic");
INSERT INTO "country" VALUES ("UZB", "33000000", "72.0", "60000.0", "Republic");
INSERT INTO "country" VALUES ("TKM", "6000000", "69.0", "40000.0", "Republic");
INSERT INTO "country" VALUES ("KGZ", "6000000", "71.0", "10000.0", "Republic");
INSERT INTO "country" VALUES ("TJK", "9000000", "70.0", "8000.0", "Republic");
INSERT INTO "country" VALUES ("MNG", "3000000", "69.0", "15000.0", "Republic");
INSERT INTO "country" VALUES ("PRK", "25000000", "72.0", "40000.0", "Socialist Republic");
INSERT INTO "country" VALUES ("KOR", "51000000", "83.0", "1600000.0", "Republic");
INSERT INTO "country" VALUES ("JPN", "126000000", "84.0", "5000000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("TWN", "23000000", "81.0", "600000.0", "Republic");
INSERT INTO "country" VALUES ("HKG", "7000000", "85.0", "350000.0", "Special Administrative Region");
INSERT INTO "country" VALUES ("MAC", "600000", "84.0", "50000.0", "Special Administrative Region");
INSERT INTO "country" VALUES ("SGP", "5000000", "83.0", "350000.0", "Republic");
INSERT INTO "country" VALUES ("BRN", "400000", "78.0", "15000.0", "Absolute Monarchy");
INSERT INTO "country" VALUES ("TLS", "1000000", "69.0", "2000.0", "Republic");
INSERT INTO "country" VALUES ("PNG", "9000000", "64.0", "25000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("SLB", "700000", "73.0", "1000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("VUT", "300000", "72.0", "1000.0", "Parliamentary Republic");
INSERT INTO "country" VALUES ("FJI", "900000", "73.0", "5000.0", "Parliamentary Republic");
INSERT INTO "country" VALUES ("TON", "100000", "73.0", "500.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("WSM", "200000", "73.0", "1000.0", "Parliamentary Republic");
INSERT INTO "country" VALUES ("KIR", "100000", "68.0", "200.0", "Republic");
INSERT INTO "country" VALUES ("TUV", "10000", "67.0", "50.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("NRU", "10000", "65.0", "100.0", "Republic");
INSERT INTO "country" VALUES ("MHL", "50000", "73.0", "200.0", "Republic");
INSERT INTO "country" VALUES ("FSM", "100000", "70.0", "300.0", "Federal Republic");
INSERT INTO "country" VALUES ("PLW", "20000", "73.0", "100.0", "Republic");
INSERT INTO "country" VALUES ("AUS", "25000000", "83.0", "1400000.0", "Constitutional Monarchy");
INSERT INTO "country" VALUES ("NZL", "5000000", "82.0", "200000.0", "Constitutional Monarchy");