CREATE TABLE cia(
	name	char(50),
	region	char(20),
	area	decimal(10),
	population	decimal(15),
	gdp	decimal(15),
	primary key (name)
);

INSERT INTO cia VALUES
('Afghanistan','Asia',652230,31822848,45300000000),
('Bangladesh','Asia',143998,166280712,324600000000),
('Bhutan','Asia',38394,733643,5235000000),
('China','Asia',9596960,1355692576,13390000000000),
('India','Asia',3287263,1236344631,4990000000000),
('Japan','Asia',377915,127103388,4729000000000),
('Korea,North','Asia',120538,24851627,40000000000),
('Korea,South','Asia',99720,49039986,1666000000000),
('Maldives','Asia',298,393595,3073000000),
('Mongolia','Asia',1564116,2953190,17030000000),
('Nepal','Asia',147181,30986975,42060000000),
('Pakistan','Asia',796095,196174380,574100000000),
('Russia','Asia',17098242,142470272,2553000000000),
('Sri Lanka','Asia',65610,21866445,134500000000),
('Greenland','Arctic',2166086,57728,2133000000),
('Iceland','Arctic',103000,317351,13110000000),
('Jan Mayen','Arctic',377,0,0),
('Svalbard','Arctic',62045,1872,0),
('Antarctica','Antarctic',14000000,0,0),
('Bouvet Island','Antarctic',49,0,0),
('French Southern and Antarctic Lands','Antarctic',55,0,0),
('Heard Island and McDonald Islands','Antarctic',412,0,0),
('South Georgia and South Sandwich Islands','Antarctic',3903,0,0),
('Nigeria','Africa',923768,177155754,478500000000),
('Egypt','Africa',1001450,86895099,551400000000),
('Ethiopia','Africa',1104300,96633458,118200000000),
('Congo,Democratic Republic','Africa',2344858,77433744,29390000000),
('South Africa','Africa',1219090,48375645,595700000000),
('Tanzania','Africa',947300,49639138,79290000000),
('Sudan','Africa',1861484,35482233,89970000000),
('Algeria','Africa',2381741,38813722,284700000000),
('Kenya','Africa',580367,45010056,79900000000),
('Morocco','Africa',446550,32987206,180000000000),
('Uganda','Africa',241038,35918915,54370000000),
('Ghana','Africa',238533,25758108,90410000000),
('Mozambique','Africa',799380,24692144,28150000000),
('Cote d''Ivoire','Africa',322463,22848945,43670000000),
('Madagascar','Africa',587041,23201926,22030000000),
('Cameroon','Africa',475440,23130708,53160000000),
('Burkina Faso','Africa',274200,18365123,26510000000),
('Zimbabwe','Africa',390757,13771721,7496000000),
('Mali','Africa',1240192,16455903,18900000000),
('Malawi','Africa',118484,17377468,15020000000),
('Angola','Africa',1246700,19088106,131800000000),
('Niger','Africa',1267000,17466172,13980000000),
('Senegal','Africa',196722,13635927,27720000000),
('Zambia','Africa',752618,14638505,25470000000),
('Chad','Africa',1284000,11412107,28000000000),
('Guinea','Africa',245857,11474383,12560000000),
('Somalia','Africa',637657,10428043,5896000000),
('Rwanda','Africa',26338,12337138,16370000000),
('Benin','Africa',112622,10160556,16650000000),
('Burundi','Africa',27830,10395931,5750000000),
('Sierra Leone','Africa',71740,5743725,9156000000),
('Libya','Africa',1759540,6244174,73600000000),
('Togo','Africa',56785,7351374,7348000000),
('Eritrea','Africa',117600,6380803,4717000000),
('Central African Republic','Africa',622984,5277959,3336000000),
('Liberia','Africa',111369,4092310,2898000000),
('Congo,Republic','Africa',342000,4662446,20260000000),
('Mauritania','Africa',1030700,3516806,8204000000),
('Lesotho','Africa',30355,1942008,4265000000),
('Namibia','Africa',824292,2198406,17790000000),
('Botswana','Africa',581730,2155784,34000000000),
('Gambia','Africa',11295,1925527,3678000000),
('Guinea-Bissau','Africa',36125,1693398,2005000000),
('Gabon','Africa',267667,1672597,30060000000),
('Swaziland','Africa',17364,1419623,6259000000),
('Comoros','Africa',2235,766865,911000000),
('Equatorial Guinea','Africa',28051,722254,19680000000),
('Djibouti','Africa',23200,810179,2505000000),
('Western Sahara','Africa',266000,554795,906500000),
('Sao Tome and Principe','Africa',964,190428,421000000),
('Germany','Europe',357022,80996685,3227000000000),
('Turkey','Europe',783562,81619392,1167000000000),
('United Kingdom','Europe',243610,63742977,2387000000000),
('France','Europe',643801,66259012,2276000000000),
('Italy','Europe',301340,61680122,1805000000000),
('Spain','Europe',505370,47737941,1389000000000),
('Poland','Europe',312685,38346279,814000000000),
('Romania','Europe',238391,21729871,288500000000),
('Netherlands','Europe',41543,16877351,699700000000),
('Serbia','Europe',77474,7209764,80470000000),
('Greece','Europe',131957,10775557,267100000000),
('Czech Republic','Europe',78867,10627448,285600000000),
('Belgium','Europe',30528,10449361,421700000000),
('Hungary','Europe',93028,9919128,196600000000),
('Portugal','Europe',92090,10813834,243300000000),
('Sweden','Europe',450295,9723809,393800000000),
('Austria','Europe',83871,8223062,361000000000),
('Bulgaria','Europe',110879,6924716,104600000000),
('Switzerland','Europe',41277,8061516,371200000000),
('Slovakia','Europe',49035,5443583,133400000000),
('Denmark','Europe',43094,5569077,211300000000),
('Finland','Europe',338145,5268799,195500000000),
('Norway','Europe',323802,5147792,282200000000),
('Croatia','Europe',56594,4470534,78900000000),
('Ireland','Europe',70273,4832765,190400000000),
('Lithuania','Europe',65300,3505738,67430000000),
('Albania','Europe',28748,3020209,28340000000),
('Latvia','Europe',64589,2165165,38870000000),
('Macedonia','Europe',25713,2091719,22570000000),
('Slovenia','Europe',20273,1988292,57360000000),
('Estonia','Europe',45228,1257921,29940000000),
('Luxembourg','Europe',2586,520672,42670000000),
('Malta','Europe',316,412655,11220000000),
('Jersey','Europe',116,96513,5100000000),
('Isle of Man','Europe',572,86866,4076000000),
('Andorra','Europe',468,85458,3163000000),
('Guernsey','Europe',78,65849,2742000000),
('Faroe Islands','Europe',1393,49947,1471000000),
('Liechtenstein','Europe',160,37313,3200000000),
('Monaco','Europe',2,30508,6213000000),
('Gibraltar','Europe',7,29185,1275000000),
('San Marino','Europe',61,32742,1306000000),
('Holy See (Vatican City)','Europe',0,842,0),
('United States','North America',9826675,318892103,16720000000000),
('Indonesia','Southeast Asia',1904569,253609643,1285000000000),
('Brazil','South America',8514877,202656788,2416000000000),
('Mexico','North America',1964375,120286655,1845000000000),
('Philippines','Southeast Asia',300000,107668231,454300000000),
('Vietnam','Southeast Asia',331210,93421835,358900000000),
('Thailand','Southeast Asia',513120,67741401,673000000000),
('Burma','Southeast Asia',676578,55746253,111100000000),
('Colombia','Caribbean',1138910,46245297,526500000000),
('Argentina','South America',2780400,43024374,771000000000),
('Canada','North America',9984670,34834841,1518000000000),
('Peru','South America',1285216,30147935,344000000000),
('Venezuela','Caribbean',912050,28868486,407400000000),
('Taiwan','Southeast Asia',35980,23359928,926400000000),
('Malaysia','Southeast Asia',329847,30073353,525000000000),
('Australia','Oceania',7741220,22507617,998300000000),
('Chile','South America',756102,17363894,335400000000),
('Ecuador','South America',283561,15654411,157600000000),
('Cambodia','Southeast Asia',181035,15458332,39640000000),
('Bolivia','South America',1098581,10631486,59110000000),
('Hong Kong','Southeast Asia',1104,7112688,381300000000),
('Paraguay','South America',406752,6703860,45900000000),
('Laos','Southeast Asia',236800,6803699,20780000000),
('Papua New Guinea','Oceania',462840,6552730,19960000000),
('Singapore','Southeast Asia',697,5567301,339000000000),
('New Zealand','Oceania',267710,4401916,136000000000),
('Uruguay','South America',176215,3332972,56270000000),
('Mauritius','Africa',2040,1331155,20950000000),
('Fiji','Oceania',18274,903207,4450000000),
('Guyana','South America',214969,735554,6593000000),
('Solomon Islands','Oceania',28896,609883,1958000000),
('Macau','Southeast Asia',28,587914,51680000000),
('Suriname','South America',163820,573311,7120000000),
('Brunei','Southeast Asia',5765,422675,22250000000),
('French Polynesia','Oceania',4167,280026,5650000000),
('New Caledonia','Oceania',18575,267840,9280000000),
('Vanuatu','Oceania',12189,266937,1270000000),
('Samoa','Oceania',2831,196628,1145000000),
('Guam','Oceania',544,161001,4600000000),
('Micronesia,Federated States of','Oceania',702,105681,754000000),
('Tonga','Oceania',747,106440,846000000),
('Kiribati','Oceania',811,104488,698000000),
('Northern Mariana Islands','Oceania',464,51483,733000000),
('Marshall Islands','Oceania',181,70983,486000000),
('American Samoa','Oceania',199,54517,575300000),
('Bermuda','North America',54,69839,5600000000),
('Cook Islands','Oceania',236,10134,183200000),
('Palau','Oceania',459,21186,245500000),
('Wallis and Futuna','Oceania',142,15561,60000000),
('Nauru','Oceania',21,9488,60000000),
('Saint Pierre and Miquelon','North America',242,5716,215300000),
('Falkland Islands (Islas Malvinas)','South America',12173,2840,164500000),
('Christmas Island','Southeast Asia',135,1530,0),
('Cocos (Keeling) Islands','Southeast Asia',14,596,0),
('Iran','Middle East',1648195,80840713,987100000000),
('Iraq','Middle East',438317,32585692,249400000000),
('Saudi Arabia','Middle East',2149690,27345986,927800000000),
('Yemen','Middle East',527968,26052966,61630000000),
('Syria','Middle East',185180,17951639,107600000000),
('Tunisia','Middle East',163610,10937521,108400000000),
('Israel','Middle East',20770,7821850,273200000000),
('Jordan','Middle East',89342,7930491,40020000000),
('Lebanon','Middle East',10400,5882562,64310000000),
('Oman','Middle East',309500,3219775,94860000000),
('United Arab Emirates','Middle East',83600,5628805,269800000000),
('West Bank','Middle East',5860,2731052,8022000000),
('Kuwait','Middle East',17818,2742711,165800000000),
('Gaza Strip','Middle East',360,1816379,0),
('Cyprus','Middle East',9251,1172458,21620000000),
('Qatar','Middle East',11586,2123160,198700000000),
('Bahrain','Middle East',760,1314089,34960000000),
('Tuvalu','Oceania',26,10782,40000000),
('Niue','Oceania',260,1190,10010000),
('Norfolk Island','Oceania',36,2210,0),
('Tokelau','Oceania',12,1337,1500000),
('Pitcairn Islands','Oceania',47,48,0),
('Seychelles','Africa',455,91650,2404000000),
('Cayman Islands','Africa',264,54914,2250000000),
('Saint Helena','Africa',308,7776,31100000),
('Montenegro','Europe',13812,650036,7429000000);
