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,
"Name" CHAR(35),
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Region" CHAR(26),
"SurfaceArea" FLOAT,
"Population" INT,
PRIMARY KEY ("Code")
);





INSERT INTO "city" VALUES ("1", "Kabul");
INSERT INTO "city" VALUES ("2", "Qandahar");
INSERT INTO "city" VALUES ("3", "Herat");
INSERT INTO "city" VALUES ("4", "Mazar-e-Sharif");
INSERT INTO "city" VALUES ("5", "Amsterdam");
INSERT INTO "city" VALUES ("6", "Rotterdam");
INSERT INTO "city" VALUES ("7", "The Hague");
INSERT INTO "city" VALUES ("8", "Utrecht");
INSERT INTO "city" VALUES ("9", "Eindhoven");
INSERT INTO "city" VALUES ("10", "Groningen");
INSERT INTO "city" VALUES ("11", "Leiden");
INSERT INTO "city" VALUES ("12", "Haarlem");
INSERT INTO "city" VALUES ("13", "Maastricht");
INSERT INTO "city" VALUES ("14", "Arnhem");
INSERT INTO "city" VALUES ("15", "Breda");
INSERT INTO "city" VALUES ("16", "Nijmegen");
INSERT INTO "city" VALUES ("17", "Apeldoorn");
INSERT INTO "city" VALUES ("18", "Enschede");
INSERT INTO "city" VALUES ("19", "Amersfoort");
INSERT INTO "city" VALUES ("20", "Dordrecht");
INSERT INTO "country" VALUES ("AFG", "Asia", "Southern and Central Asia", "652090.00", "22720000");
INSERT INTO "country" VALUES ("NLD", "Europe", "Western Europe", "41526.00", "15988000");
INSERT INTO "country" VALUES ("ALB", "Europe", "Southern Europe", "28748.00", "3401200");
INSERT INTO "country" VALUES ("DZA", "Africa", "Northern Africa", "2381741.00", "31471000");
INSERT INTO "country" VALUES ("ASM", "Oceania", "Polynesia", "199.00", "68000");
INSERT INTO "country" VALUES ("AND", "Europe", "Southern Europe", "468.00", "78000");
INSERT INTO "country" VALUES ("AGO", "Africa", "Central Africa", "1246700.00", "12878000");
INSERT INTO "country" VALUES ("AIA", "North America", "Caribbean", "96.00", "8000");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "13139500.00", "0");
INSERT INTO "country" VALUES ("ATG", "North America", "Caribbean", "442.00", "68000");
INSERT INTO "country" VALUES ("ARG", "South America", "South America", "2780400.00", "37032000");
INSERT INTO "country" VALUES ("ARM", "Asia", "Middle East", "29800.00", "3520000");
INSERT INTO "country" VALUES ("ABW", "North America", "Caribbean", "193.00", "103000");
INSERT INTO "country" VALUES ("AUS", "Oceania", "Australia and New Zealand", "7741220.00", "18886000");
INSERT INTO "country" VALUES ("AUT", "Europe", "Western Europe", "83859.00", "8078000");
INSERT INTO "country" VALUES ("AZE", "Asia", "Middle East", "86600.00", "7734000");
INSERT INTO "country" VALUES ("BHS", "North America", "Caribbean", "13878.00", "307000");
INSERT INTO "country" VALUES ("BHR", "Asia", "Middle East", "694.00", "617000");
INSERT INTO "country" VALUES ("BGD", "Asia", "Southern and Central Asia", "144000.00", "129155000");
INSERT INTO "country" VALUES ("BRB", "North America", "Caribbean", "430.00", "274000");
INSERT INTO "country" VALUES ("BLR", "Europe", "Eastern Europe", "207600.00", "10236000");
INSERT INTO "country" VALUES ("BEL", "Europe", "Western Europe", "30518.00", "10239000");
INSERT INTO "country" VALUES ("BLZ", "North America", "Central America", "22966.00", "241000");
INSERT INTO "country" VALUES ("BEN", "Africa", "Western Africa", "112622.00", "6097000");
INSERT INTO "country" VALUES ("BMU", "North America", "North America", "53.00", "65000");
INSERT INTO "country" VALUES ("BTN", "Asia", "Southern and Central Asia", "47000.00", "2124000");
INSERT INTO "country" VALUES ("BOL", "South America", "South America", "1098581.00", "8329000");
INSERT INTO "country" VALUES ("BIH", "Europe", "Southern Europe", "51197.00", "3972000");
INSERT INTO "country" VALUES ("BWA", "Africa", "Southern Africa", "581730.00", "1622000");
INSERT INTO "country" VALUES ("BVT", "Antarctica", "Antarctica", "49.00", "0");
INSERT INTO "country" VALUES ("BRA", "South America", "South America", "8547403.00", "170115000");
INSERT INTO "country" VALUES ("IOT", "Africa", "Eastern Africa", "78.00", "0");
INSERT INTO "country" VALUES ("BRN", "Asia", "South-Eastern Asia", "5765.00", "336000");
INSERT INTO "country" VALUES ("BGR", "Europe", "Eastern Europe", "110994.00", "8190000");
INSERT INTO "country" VALUES ("BFA", "Africa", "Western Africa", "274000.00", "11937000");
INSERT INTO "country" VALUES ("BDI", "Africa", "Eastern Africa", "27834.00", "6695000");
INSERT INTO "country" VALUES ("KHM", "Asia", "South-Eastern Asia", "181035.00", "11168000");
INSERT INTO "country" VALUES ("CMR", "Africa", "Central Africa", "475442.00", "15085000");
INSERT INTO "country" VALUES ("CAN", "North America", "North America", "9970610.00", "31147000");
INSERT INTO "country" VALUES ("CPV", "Africa", "Western Africa", "4033.00", "435000");
INSERT INTO "country" VALUES ("CYM", "North America", "Caribbean", "264.00", "38000");
INSERT INTO "country" VALUES ("CAF", "Africa", "Central Africa", "622984.00", "3701000");
INSERT INTO "country" VALUES ("TCD", "Africa", "Central Africa", "1284000.00", "7618000");
INSERT INTO "country" VALUES ("CHL", "South America", "South America", "756102.00", "15211000");
INSERT INTO "country" VALUES ("CHN", "Asia", "Eastern Asia", "9572900.00", "1277558000");
INSERT INTO "country" VALUES ("CXR", "Oceania", "Australia and New Zealand", "135.00", "2500");
INSERT INTO "country" VALUES ("CCK", "Oceania", "Australia and New Zealand", "14.00", "600");
INSERT INTO "country" VALUES ("COL", "South America", "South America", "1138914.00", "42321000");
INSERT INTO "country" VALUES ("COM", "Africa", "Eastern Africa", "1862.00", "578000");
INSERT INTO "country" VALUES ("COG", "Africa", "Central Africa", "342000.00", "2943000");
INSERT INTO "country" VALUES ("COD", "Africa", "Central Africa", "2344858.00", "51654000");
INSERT INTO "country" VALUES ("COK", "Oceania", "Polynesia", "236.00", "20000");
INSERT INTO "country" VALUES ("CRI", "North America", "Central America", "51100.00", "4023000");
INSERT INTO "country" VALUES ("CIV", "Africa", "Western Africa", "322462.00", "14782000");
INSERT INTO "country" VALUES ("HRV", "Europe", "Southern Europe", "56542.00", "4473000");
INSERT INTO "country" VALUES ("CUB", "North America", "Caribbean", "110861.00", "11220000");
INSERT INTO "country" VALUES ("CYP", "Asia", "Middle East", "9251.00", "787000");
INSERT INTO "country" VALUES ("CZE", "Europe", "Eastern Europe", "78866.00", "10278100");
INSERT INTO "country" VALUES ("DNK", "Europe", "Northern Europe", "43094.00", "5340000");
INSERT INTO "country" VALUES ("DJI", "Africa", "Eastern Africa", "23200.00", "691000");
INSERT INTO "country" VALUES ("DMA", "North America", "Caribbean", "751.00", "71000");
INSERT INTO "country" VALUES ("DOM", "North America", "Caribbean", "48511.00", "8495000");
INSERT INTO "country" VALUES ("ECU", "South America", "South America", "283561.00", "12646000");
INSERT INTO "country" VALUES ("EGY", "Africa", "Northern Africa", "1001450.00", "68470000");
INSERT INTO "country" VALUES ("SLV", "North America", "Central America", "21041.00", "6218000");
INSERT INTO "country" VALUES ("GNQ", "Africa", "Central Africa", "28051.00", "453000");
INSERT INTO "country" VALUES ("ERI", "Africa", "Eastern Africa", "117600.00", "3850000");
INSERT INTO "country" VALUES ("EST", "Europe", "Eastern Europe", "45227.00", "1439200");
INSERT INTO "country" VALUES ("ETH", "Africa", "Eastern Africa", "1133887.00", "62565000");
INSERT INTO "country" VALUES ("FLK", "South America", "South America", "12173.00", "2000");
INSERT INTO "country" VALUES ("FRO", "Europe", "Northern Europe", "1399.00", "43000");
INSERT INTO "country" VALUES ("FJI", "Oceania", "Melanesia", "18274.00", "817000");
INSERT INTO "country" VALUES ("FIN", "Europe", "Northern Europe", "338145.00", "5171000");
INSERT INTO "country" VALUES ("FRA", "Europe", "Western Europe", "551500.00", "59226000");
INSERT INTO "country" VALUES ("GUF", "South America", "South America", "90000.00", "181000");
INSERT INTO "country" VALUES ("PYF", "Oceania", "Polynesia", "4167.00", "235000");
INSERT INTO "country" VALUES ("ATF", "Antarctica", "Antarctica", "7829.00", "0");
INSERT INTO "country" VALUES ("GAB", "Africa", "Central Africa", "267668.00", "1226000");
INSERT INTO "country" VALUES ("GMB", "Africa", "Western Africa", "11295.00", "1305000");
INSERT INTO "country" VALUES ("GEO", "Asia", "Middle East", "69700.00", "4968000");
INSERT INTO "country" VALUES ("DEU", "Europe", "Western Europe", "357022.00", "82164000");
INSERT INTO "country" VALUES ("GHA", "Africa", "Western Africa", "238533.00", "20212000");
INSERT INTO "country" VALUES ("GIB", "Europe", "Southern Europe", "6.00", "25000");
INSERT INTO "country" VALUES ("GRC", "Europe", "Southern Europe", "131626.00", "10545000");
INSERT INTO "country" VALUES ("GRL", "North America", "North America", "2166090.00", "56000");
INSERT INTO "country" VALUES ("GRD", "North America", "Caribbean", "344.00", "94000");
INSERT INTO "country" VALUES ("GLP", "North America", "Caribbean", "1705.00", "456000");
INSERT INTO "country" VALUES ("GUM", "Oceania", "Micronesia", "549.00", "168000");
INSERT INTO "country" VALUES ("GTM", "North America", "Central America", "108889.00", "11385000");
INSERT INTO "country" VALUES ("GIN", "Africa", "Western Africa", "245857.00", "7430000");
INSERT INTO "country" VALUES ("GNB", "Africa", "Western Africa", "36125.00", "1213000");
INSERT INTO "country" VALUES ("GUY", "South America", "South America", "214969.00", "701000");
INSERT INTO "country" VALUES ("HTI", "North America", "Caribbean", "27750.00", "8222000");
INSERT INTO "country" VALUES ("HMD", "Antarctica", "Antarctica", "359.00", "0");
INSERT INTO "country" VALUES ("HND", "North America", "Central America", "112088.00", "6485000");
INSERT INTO "country" VALUES ("HKG", "Asia", "Eastern Asia", "1075.00", "6782000");
INSERT INTO "country" VALUES ("HUN", "Europe", "Eastern Europe", "93030.00", "10042000");
INSERT INTO "country" VALUES ("ISL", "Europe", "Northern Europe", "103000.00", "279000");
INSERT INTO "country" VALUES ("IND", "Asia", "Southern and Central Asia", "3287263.00", "1013662000");
INSERT INTO "country" VALUES ("IDN", "Asia", "South-Eastern Asia", "1919446.00", "212107000");
INSERT INTO "country" VALUES ("IRN", "Asia", "Southern and Central Asia", "1648195.00", "67697000");
INSERT INTO "country" VALUES ("IRQ", "Asia", "Middle East", "438317.00", "23115000");
INSERT INTO "country" VALUES ("IRL", "Europe", "Northern Europe", "70273.00", "3775100");
INSERT INTO "country" VALUES ("ISR", "Asia", "Middle East", "20769.00", "6217000");
INSERT INTO "country" VALUES ("ITA", "Europe", "Southern Europe", "301316.00", "57679000");
INSERT INTO "country" VALUES ("JAM", "North America", "Caribbean", "10991.00", "2664000");
INSERT INTO "country" VALUES ("JPN", "Asia", "Eastern Asia", "377829.00", "126714000");
INSERT INTO "country" VALUES ("JOR", "Asia", "Middle East", "89342.00", "5083000");
INSERT INTO "country" VALUES ("KAZ", "Asia", "Southern and Central Asia", "2724900.00", "16223000");
INSERT INTO "country" VALUES ("KEN", "Africa", "Eastern Africa", "581309.00", "30080000");
INSERT INTO "country" VALUES ("KIR", "Oceania", "Micronesia", "811.00", "83000");
INSERT INTO "country" VALUES ("PRK", "Asia", "Eastern Asia", "120538.00", "23479000");
INSERT INTO "country" VALUES ("KOR", "Asia", "Eastern Asia", "99434.00", "46844000");
INSERT INTO "country" VALUES ("KWT", "Asia", "Middle East", "17818.00", "1972000");
INSERT INTO "country" VALUES ("KGZ", "Asia", "Southern and Central Asia", "199900.00", "4699000");
INSERT INTO "country" VALUES ("LAO", "Asia", "South-Eastern Asia", "236800.00", "5433000");
INSERT INTO "country" VALUES ("LVA", "Europe", "Eastern Europe", "64589.00", "2424200");
INSERT INTO "country" VALUES ("LBN", "Asia", "Middle East", "10452.00", "3286000");
INSERT INTO "country" VALUES ("LSO", "Africa", "Southern Africa", "30355.00", "2153000");
INSERT INTO "country" VALUES ("LBR", "Africa", "Western Africa", "111369.00", "3154000");
INSERT INTO "country" VALUES ("LBY", "Africa", "Northern Africa", "1759540.00", "5670000");
INSERT INTO "country" VALUES ("LIE", "Europe", "Western Europe", "160.00", "32000");
INSERT INTO "country" VALUES ("LTU", "Europe", "Eastern Europe", "65300.00", "3698500");
INSERT INTO "country" VALUES ("LUX", "Europe", "Western Europe", "2586.00", "435000");
INSERT INTO "country" VALUES ("MAC", "Asia", "Eastern Asia", "18.00", "473000");
INSERT INTO "country" VALUES ("MKD", "Europe", "Southern Europe", "25713.00", "2024000");
INSERT INTO "country" VALUES ("MDG", "Africa", "Eastern Africa", "587041.00", "15942000");
INSERT INTO "country" VALUES ("MWI", "Africa", "Eastern Africa", "118484.00", "10925000");
INSERT INTO "country" VALUES ("MYS", "Asia", "South-Eastern Asia", "329758.00", "22244000");
INSERT INTO "country" VALUES ("MDV", "Asia", "Southern and Central Asia", "300.00", "286000");
INSERT INTO "country" VALUES ("MLI", "Africa", "Western Africa", "1240192.00", "11241000");
INSERT INTO "country" VALUES ("MLT", "Europe", "Southern Europe", "316.00", "392000");
INSERT INTO "country" VALUES ("MHL", "Oceania", "Micronesia", "181.00", "64000");
INSERT INTO "country" VALUES ("MRT", "Africa", "Western Africa", "1025520.00", "2670000");
INSERT INTO "country" VALUES ("MUS", "Africa", "Eastern Africa", "2040.00", "1158000");
INSERT INTO "country" VALUES ("MEX", "North America", "Central America", "1958201.00", "98881000");
INSERT INTO "country" VALUES ("FSM", "Oceania", "Micronesia", "702.00", "119000");
INSERT INTO "country" VALUES ("MDA", "Europe", "Eastern Europe", "33851.00", "4380000");
INSERT INTO "country" VALUES ("MCO", "Europe", "Western Europe", "1.50", "34000");
INSERT INTO "country" VALUES ("MNG", "Asia", "Eastern Asia", "1566500.00", "2662000");
INSERT INTO "country" VALUES ("MSR", "North America", "Caribbean", "102.00", "11000");
INSERT INTO "country" VALUES ("MAR", "Africa", "Northern Africa", "446550.00", "29141000");
INSERT INTO "country" VALUES ("MOZ", "Africa", "Eastern Africa", "801590.00", "19686000");
INSERT INTO "country" VALUES ("MMR", "Asia", "South-Eastern Asia", "676578.00", "45611000");
INSERT INTO "country" VALUES ("NAM", "Africa", "Southern Africa", "824292.00", "1726000");
INSERT INTO "country" VALUES ("NRU", "Oceania", "Micronesia", "21.00", "12000");
INSERT INTO "country" VALUES ("NPL", "Asia", "Southern and Central Asia", "147181.00", "23949000");
INSERT INTO "country" VALUES ("ANT", "North America", "Caribbean", "444.00", "217000");
INSERT INTO "country" VALUES ("NCL", "Oceania", "Melanesia", "18575.00", "214000");
INSERT INTO "country" VALUES ("NZL", "Oceania", "Australia and New Zealand", "270534.00", "3862000");
INSERT INTO "country" VALUES ("NIC", "North America", "Central America", "130000.00", "5074000");
INSERT INTO "country" VALUES ("NER", "Africa", "Western Africa", "1267000.00", "10730000");
INSERT INTO "country" VALUES ("NGA", "Africa", "Western Africa", "923768.00", "115220000");
INSERT INTO "country" VALUES ("NIU", "Oceania", "Polynesia", "260.00", "2000");
INSERT INTO "country" VALUES ("NFK", "Oceania", "Australia and New Zealand", "36.00", "2000");
INSERT INTO "country" VALUES ("MNP", "Oceania", "Micronesia", "464.00", "78000");
INSERT INTO "country" VALUES ("NOR", "Europe", "Northern Europe", "323877.00", "4478000");
INSERT INTO "country" VALUES ("OMN", "Asia", "Middle East", "309500.00", "2542000");
INSERT INTO "country" VALUES ("PAK", "Asia", "Southern and Central Asia", "796095.00", "156487000");
INSERT INTO "country" VALUES ("PLW", "Oceania", "Micronesia", "458.00", "19000");
INSERT INTO "country" VALUES ("PSE", "Asia", "Middle East", "6257.00", "3133000");
INSERT INTO "country" VALUES ("PAN", "North America", "Central America", "75517.00", "2856000");
INSERT INTO "country" VALUES ("PNG", "Oceania", "Melanesia", "462840.00", "5049000");
INSERT INTO "country" VALUES ("PRY", "South America", "South America", "406752.00", "5496000");
INSERT INTO "country" VALUES ("PER", "South America", "South America", "1285216.00", "25662000");
INSERT INTO "country" VALUES ("PHL", "Asia", "South-Eastern Asia", "300000.00", "75974000");
INSERT INTO "country" VALUES ("PCN", "Oceania", "Polynesia", "47.00", "50");
INSERT INTO "country" VALUES ("POL", "Europe", "Eastern Europe", "312683.00", "38625000");
INSERT INTO "country" VALUES ("PRT", "Europe", "Southern Europe", "91982.00", "9997000");
INSERT INTO "country" VALUES ("PRI", "North America", "Caribbean", "8875.00", "3860000");
INSERT INTO "country" VALUES ("QAT", "Asia", "Middle East", "11000.00", "599000");
INSERT INTO "country" VALUES ("REU", "Africa", "Eastern Africa", "2510.00", "720000");
INSERT INTO "country" VALUES ("ROM", "Europe", "Eastern Europe", "237502.00", "22455000");