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 "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Population" INT,
"GNP" FLOAT,
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("AFG", "Asia", "22720000", "5976.0");
INSERT INTO "country" VALUES ("NLD", "Europe", "15987000", "371362.0");
INSERT INTO "country" VALUES ("ANT", "North America", "217000", "1940.0");
INSERT INTO "country" VALUES ("ALB", "Europe", "3401200", "3205.0");
INSERT INTO "country" VALUES ("DZA", "Africa", "31471000", "49982.0");
INSERT INTO "country" VALUES ("ASM", "Oceania", "68000", "300.0");
INSERT INTO "country" VALUES ("AND", "Europe", "78000", "1630.0");
INSERT INTO "country" VALUES ("AGO", "Africa", "12878000", "6648.0");
INSERT INTO "country" VALUES ("AIA", "North America", "8000", "108.0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "0", "0.0");
INSERT INTO "country" VALUES ("ATG", "North America", "68000", "751.0");
INSERT INTO "country" VALUES ("ARG", "South America", "37032000", "340238.0");
INSERT INTO "country" VALUES ("ARM", "Asia", "3520000", "1813.0");
INSERT INTO "country" VALUES ("ABW", "North America", "103000", "1304.0");
INSERT INTO "country" VALUES ("AUS", "Oceania", "18886000", "351100.0");
INSERT INTO "country" VALUES ("AUT", "Europe", "8078900", "211860.0");
INSERT INTO "country" VALUES ("AZE", "Asia", "7734000", "4127.0");
INSERT INTO "country" VALUES ("BHS", "North America", "307000", "3527.0");
INSERT INTO "country" VALUES ("BHR", "Asia", "617000", "6366.0");
INSERT INTO "country" VALUES ("BGD", "Asia", "129155000", "32852.0");
INSERT INTO "country" VALUES ("BRB", "North America", "270000", "2223.0");
INSERT INTO "country" VALUES ("BLR", "Europe", "10335000", "13714.0");
INSERT INTO "country" VALUES ("BEL", "Europe", "10239000", "249704.0");
INSERT INTO "country" VALUES ("BLZ", "North America", "241000", "630.0");
INSERT INTO "country" VALUES ("BEN", "Africa", "6096000", "2357.0");
INSERT INTO "country" VALUES ("BMU", "North America", "65000", "2320.0");
INSERT INTO "country" VALUES ("BTN", "Asia", "2124000", "372.0");
INSERT INTO "country" VALUES ("BOL", "South America", "8329000", "8232.0");
INSERT INTO "country" VALUES ("BIH", "Europe", "3972000", "4107.0");
INSERT INTO "country" VALUES ("BWA", "Africa", "1622000", "4834.0");
INSERT INTO "country" VALUES ("BVT", "Antarctica", "0", "0.0");
INSERT INTO "country" VALUES ("BRA", "South America", "170115000", "776739.0");
INSERT INTO "country" VALUES ("IOT", "Africa", "0", "0.0");
INSERT INTO "country" VALUES ("BRN", "Asia", "328000", "3563.0");
INSERT INTO "country" VALUES ("BGR", "Europe", "8190900", "12182.0");
INSERT INTO "country" VALUES ("BFA", "Africa", "11937000", "2423.0");
INSERT INTO "country" VALUES ("BDI", "Africa", "6695000", "1096.0");
INSERT INTO "country" VALUES ("KHM", "Asia", "11168000", "2188.0");
INSERT INTO "country" VALUES ("CMR", "Africa", "15085000", "9174.0");
INSERT INTO "country" VALUES ("CAN", "North America", "31147000", "720431.0");
INSERT INTO "country" VALUES ("CPV", "Africa", "435000", "402.0");
INSERT INTO "country" VALUES ("CYM", "North America", "38000", "1263.0");
INSERT INTO "country" VALUES ("CAF", "Africa", "3701000", "1539.0");
INSERT INTO "country" VALUES ("TCD", "Africa", "7618000", "1208.0");
INSERT INTO "country" VALUES ("CHL", "South America", "15211000", "72784.0");
INSERT INTO "country" VALUES ("CHN", "Asia", "1277558000", "982788.0");
INSERT INTO "country" VALUES ("CXR", "Oceania", "2500", "0.0");
INSERT INTO "country" VALUES ("CCK", "Oceania", "600", "0.0");
INSERT INTO "country" VALUES ("COL", "South America", "42321000", "102876.0");
INSERT INTO "country" VALUES ("COM", "Africa", "578000", "299.0");
INSERT INTO "country" VALUES ("COG", "Africa", "2943000", "2108.0");
INSERT INTO "country" VALUES ("COD", "Africa", "50626000", "9958.0");
INSERT INTO "country" VALUES ("COK", "Oceania", "20000", "100.0");
INSERT INTO "country" VALUES ("CRI", "North America", "4023000", "10212.0");
INSERT INTO "country" VALUES ("CIV", "Africa", "14782000", "11345.0");
INSERT INTO "country" VALUES ("HRV", "Europe", "4447000", "20226.0");
INSERT INTO "country" VALUES ("CUB", "North America", "11187000", "17771.0");
INSERT INTO "country" VALUES ("CYP", "Asia", "754700", "9333.0");
INSERT INTO "country" VALUES ("CZE", "Europe", "10278100", "55017.0");
INSERT INTO "country" VALUES ("DNK", "Europe", "5330000", "164074.0");
INSERT INTO "country" VALUES ("DJI", "Africa", "691000", "194.0");
INSERT INTO "country" VALUES ("DMA", "North America", "71000", "256.0");
INSERT INTO "country" VALUES ("DOM", "North America", "8495000", "16232.0");
INSERT INTO "country" VALUES ("ECU", "South America", "12646000", "21574.0");
INSERT INTO "country" VALUES ("EGY", "Africa", "68470000", "75617.0");
INSERT INTO "country" VALUES ("SLV", "North America", "6218000", "11825.0");
INSERT INTO "country" VALUES ("GNQ", "Africa", "453000", "900.0");
INSERT INTO "country" VALUES ("ERI", "Africa", "3850000", "650.0");
INSERT INTO "country" VALUES ("EST", "Europe", "1439200", "5326.0");
INSERT INTO "country" VALUES ("ETH", "Africa", "62565000", "6171.0");
INSERT INTO "country" VALUES ("FLK", "South America", "2000", "0.0");
INSERT INTO "country" VALUES ("FRO", "Europe", "43000", "0.0");