bbc.sql

CREATE TABLE bbc (name varchar(50) NOT NULL PRIMARY KEY,region varchar(60) NULL,area decimal(10,0) NULL,population decimal(11,0) NULL,gdp decimal(14,0) NULL,index(region));

INSERT INTO bbc VALUES ("Afghanistan",'South Asia',652225,26000000,null);
INSERT INTO bbc VALUES ("Albania",'Europe',28728,3200000,6656000000);
INSERT INTO bbc VALUES ("Algeria",'Middle East',2400000,32900000,75012000000);
INSERT INTO bbc VALUES ("Andorra",'Europe',468,64000,null);
INSERT INTO bbc VALUES ("Angola",'Africa',1250000,14500000,14935000000);
INSERT INTO bbc VALUES ("Antigua and Barbuda",'Americas',442,77000,770000000);
INSERT INTO bbc VALUES ("Argentina",'South America',2800000,39300000,1.46196E+11);
INSERT INTO bbc VALUES ("Armenia",'Europe',29743,3000000,3360000000);
INSERT INTO bbc VALUES ("Australia",'Asia-Pacific',7700000,20300000,5.4607E+11);
INSERT INTO bbc VALUES ("Austria",'Europe',83871,8100000,2.6163E+11);
INSERT INTO bbc VALUES ("Azerbaijan",'Europe',86600,8500000,null);
INSERT INTO bbc VALUES ("Bahamas",'Americas',13939,321000,4789320000);
INSERT INTO bbc VALUES ("Bahrain",'Middle East',717,754000,9357140000);
INSERT INTO bbc VALUES ("Bangladesh",'South Asia',143998,152600000,67144000000);
INSERT INTO bbc VALUES ("Barbados",'Americas',430,272000,2518720000);
INSERT INTO bbc VALUES ("Belarus",'Europe',207595,9800000,20776000000);
INSERT INTO bbc VALUES ("Belgium",'Europe',30528,10300000,3.19609E+11);
INSERT INTO bbc VALUES ("Belize",'Americas',22965,266000,null);
INSERT INTO bbc VALUES ("Benin",'Africa',112622,7100000,3763000000);
INSERT INTO bbc VALUES ("Bhutan",'South Asia',38364,2400000,1824000000);
INSERT INTO bbc VALUES ("Bolivia",'South America',1100000,9100000,null);
INSERT INTO bbc VALUES ("Bosnia-Hercegovina",'Europe',51129,4200000,8568000000);
INSERT INTO bbc VALUES ("Botswana",'Africa',581730,1800000,7812000000);
INSERT INTO bbc VALUES ("Brazil",'South America',8550000,182800000,5.64852E+11);
INSERT INTO bbc VALUES ("Brunei",'Asia-Pacific',5765,374000,null);
INSERT INTO bbc VALUES ("Bulgaria",'Europe',110994,7800000,21372000000);
INSERT INTO bbc VALUES ("Burkina Faso",'Africa',274200,13800000,4968000000);
INSERT INTO bbc VALUES ("Burma",'Asia-Pacific',676552,50700000,null);
INSERT INTO bbc VALUES ("Burundi",'Africa',27816,7300000,null);
INSERT INTO bbc VALUES ("Cambodia",'Asia-Pacific',181035,14800000,4736000000);
INSERT INTO bbc VALUES ("Cameroon",'Africa',465458,16600000,13280000000);
INSERT INTO bbc VALUES ("Canada",'North America',9900000,32000000,9.0848E+11);
INSERT INTO bbc VALUES ("Cape Verde",'Africa',4033,482000,853140000);
INSERT INTO bbc VALUES ("Central African Republic",'Africa',622984,3900000,null);
INSERT INTO bbc VALUES ("Chad",'Africa',1280000,9100000,2366000000);
INSERT INTO bbc VALUES ("Chile",'South America',756096,16200000,79542000000);
INSERT INTO bbc VALUES ("China",'Asia-Pacific',9600000,1300000000,1.677E+12);
INSERT INTO bbc VALUES ("Colombia",'South America',1140000,45600000,null);
INSERT INTO bbc VALUES ("Comoros",'Africa',1862,812000,null);
INSERT INTO bbc VALUES ("Costa Rica",'Americas',51100,4300000,null);
INSERT INTO bbc VALUES ("Croatia",'Europe',56594,4400000,28996000000);
INSERT INTO bbc VALUES ("Cuba",'Americas',110860,11300000,null);
INSERT INTO bbc VALUES ("Cyprus",'Europe',9250,807000,14187060000);
INSERT INTO bbc VALUES ("Czech Republic",'Europe',78866,10200000,93330000000);
INSERT INTO bbc VALUES ("Democratic Republic of Congo",'Africa',2340000,56000000,6720000000);
INSERT INTO bbc VALUES ("Denmark",'Europe',43098,5400000,2.1951E+11);
INSERT INTO bbc VALUES ("Djibouti",'Africa',23200,721000,null);
INSERT INTO bbc VALUES ("Dominica",'Americas',751,71000,259150000);
INSERT INTO bbc VALUES ("Dominican Republic",'Americas',48072,9000000,null);
INSERT INTO bbc VALUES ("East Timor",'Asia-Pacific',14609,857000,null);
INSERT INTO bbc VALUES ("Ecuador",'South America',272045,13400000,null);
INSERT INTO bbc VALUES ("Egypt",'Middle East',1000000,74900000,98119000000);
INSERT INTO bbc VALUES ("El Salvador",'Americas',21041,6700000,15745000000);
INSERT INTO bbc VALUES ("Equatorial Guinea",'Africa',28051,521000,484530000);
INSERT INTO bbc VALUES ("Eritrea",'Africa',117400,4561599,null);
INSERT INTO bbc VALUES ("Estonia",'Europe',45227,1300000,9113000000);
INSERT INTO bbc VALUES ("Ethiopia",'Africa',1130000,74200000,8162000000);
INSERT INTO bbc VALUES ("Fiji",'Asia-Pacific',18376,854000,null);
INSERT INTO bbc VALUES ("Finland",'Europe',338145,5200000,1.70508E+11);
INSERT INTO bbc VALUES ("Former Yugoslav Republic of Macedonia",'Europe',25713,2000000,4700000000);
INSERT INTO bbc VALUES ("France",'Europe',543965,60700000,1.82646E+12);
INSERT INTO bbc VALUES ("Gabon",'Africa',267667,1400000,null);
INSERT INTO bbc VALUES ("Georgia",'Europe',69700,5000000,5200000000);
INSERT INTO bbc VALUES ("Germany",'Europe',357027,82500000,2.4849E+12);
INSERT INTO bbc VALUES ("Ghana",'Africa',238533,21800000,8284000000);
INSERT INTO bbc VALUES ("Greece",'Europe',131957,11000000,1.8271E+11);
INSERT INTO bbc VALUES ("Grenada",'Americas',344,103000,null);
INSERT INTO bbc VALUES ("Guatemala",'Americas',108890,13000000,null);
INSERT INTO bbc VALUES ("Guinea",'Africa',245857,8800000,4048000000);
INSERT INTO bbc VALUES ("Guinea-Bissau",'Africa',36125,1600000,256000000);
INSERT INTO bbc VALUES ("Guyana",'South America',214969,768000,null);
INSERT INTO bbc VALUES ("Haiti",'Americas',27750,8500000,null);
INSERT INTO bbc VALUES ("Honduras",'Americas',112492,7200000,7416000000);
INSERT INTO bbc VALUES ("Hungary",'Europe',93030,9800000,81046000000);
INSERT INTO bbc VALUES ("Iceland",'Europe',103000,294000,11354280000);
INSERT INTO bbc VALUES ("India",'South Asia',3100000,1100000000,6.82E+11);
INSERT INTO bbc VALUES ("Indonesia",'Asia-Pacific',1900000,225300000,2.56842E+11);
INSERT INTO bbc VALUES ("Iran",'Middle East',1650000,70700000,1.6261E+11);
INSERT INTO bbc VALUES ("Iraq",'Middle East',438317,26500000,null);
INSERT INTO bbc VALUES ("Ireland",'Europe',70182,4000000,1.3712E+11);
INSERT INTO bbc VALUES ("Israel and Palestinian territories",'Middle East',20770,3800000,4256000000);
INSERT INTO bbc VALUES ("Italy",'Europe',301338,57200000,1.49406E+12);
INSERT INTO bbc VALUES ("Ivory Coast",'Africa',322462,17100000,13167000000);
INSERT INTO bbc VALUES ("Jamaica",'Americas',10991,2700000,7830000000);
INSERT INTO bbc VALUES ("Japan",'Asia-Pacific',377864,127900000,4.75532E+12);
INSERT INTO bbc VALUES ("Jordan",'Middle East',89342,5700000,12198000000);
INSERT INTO bbc VALUES ("Kazakhstan",'Asia-Pacific',2700000,15400000,null);
INSERT INTO bbc VALUES ("Kenya",'Africa',582646,32800000,15088000000);
INSERT INTO bbc VALUES ("Kiribati",'Asia-Pacific',810,85000,82450000);
INSERT INTO bbc VALUES ("Kuwait",'Middle East',17818,2700000,48519000000);
INSERT INTO bbc VALUES ("Kyrgyzstan",'Asia-Pacific',199900,5300000,null);
INSERT INTO bbc VALUES ("Laos",'Asia-Pacific',236800,5900000,2301000000);
INSERT INTO bbc VALUES ("Latvia",'Europe',64589,2300000,null);
INSERT INTO bbc VALUES ("Lebanon",'Middle East',10452,3800000,18924000000);
INSERT INTO bbc VALUES ("Lesotho",'Africa',30355,1800000,1332000000);
INSERT INTO bbc VALUES ("Liberia",'Africa',99067,3600000,396000000);
INSERT INTO bbc VALUES ("Libya",'Africa',1770000,5800000,25810000000);
INSERT INTO bbc VALUES ("Liechtenstein",'Europe',160,34000,null);
INSERT INTO bbc VALUES ("Lithuania",'Europe',65300,3400000,19516000000);
INSERT INTO bbc VALUES ("Luxembourg",'Europe',2586,465000,26146950000);
INSERT INTO bbc VALUES ("Madagascar",'Africa',587041,18400000,5520000000);
INSERT INTO bbc VALUES ("Malawi",'Africa',118484,12600000,2142000000);
INSERT INTO bbc VALUES ("Malaysia",'Asia-Pacific',329847,25300000,null);
INSERT INTO bbc VALUES ("Mali",'Africa',1250000,13800000,4968000000);
INSERT INTO bbc VALUES ("Malta",'Europe',316,397000,4863250000);
INSERT INTO bbc VALUES ("Marshall Islands",'Asia-Pacific',181,57000,135090000);
INSERT INTO bbc VALUES ("Mauritania",'Middle East',1040000,3100000,1302000000);
INSERT INTO bbc VALUES ("Mauritius",'Africa',2040,1200000,5568000000);
INSERT INTO bbc VALUES ("Mexico",'North America',1960000,106400000,7.20328E+11);
INSERT INTO bbc VALUES ("Micronesia",'Asia-Pacific',700,111000,null);
INSERT INTO bbc VALUES ("Moldova",'Europe',33800,4300000,3053000000);
INSERT INTO bbc VALUES ("Monaco",'Europe',2,32000,null);
INSERT INTO bbc VALUES ("Mongolia",'Asia-Pacific',1560000,2700000,null);
INSERT INTO bbc VALUES ("Morocco",'Middle East',710850,31600000,48032000000);
INSERT INTO bbc VALUES ("Mozambique",'Africa',812379,19500000,4875000000);
INSERT INTO bbc VALUES ("Namibia",'Africa',824292,2000000,4740000000);
INSERT INTO bbc VALUES ("Nauru",'Asia-Pacific',21,9900,null);
INSERT INTO bbc VALUES ("Nepal",'South Asia',147181,26300000,6838000000);
INSERT INTO bbc VALUES ("New Zealand",'Asia-Pacific',270534,4000000,81240000000);
INSERT INTO bbc VALUES ("Nicaragua",'Americas',120254,5700000,4503000000);
INSERT INTO bbc VALUES ("Niger",'Africa',1270000,12900000,2967000000);
INSERT INTO bbc VALUES ("Nigeria",'Africa',923768,130200000,50778000000);
INSERT INTO bbc VALUES ("North Korea",'Asia-Pacific',122762,22900000,null);
INSERT INTO bbc VALUES ("Norway",'Europe',323759,4600000,2.39338E+11);
INSERT INTO bbc VALUES ("Oman",'Middle East',309500,3000000,23670000000);
INSERT INTO bbc VALUES ("Pakistan",'South Asia',796095,161100000,96660000000);
INSERT INTO bbc VALUES ("Palau",'Asia-Pacific',508,20000,null);
INSERT INTO bbc VALUES ("Panama",'Americas',75517,3200000,null);
INSERT INTO bbc VALUES ("Papua New Guinea",'Asia-Pacific',462840,5900000,3422000000);
INSERT INTO bbc VALUES ("Paraguay",'South America',406752,6200000,null);
INSERT INTO bbc VALUES ("Peru",'South America',1280000,28000000,null);
INSERT INTO bbc VALUES ("Poland",'Europe',312685,38500000,2.34465E+11);
INSERT INTO bbc VALUES ("Portugal",'Europe',92345,10500000,1.50675E+11);
INSERT INTO bbc VALUES ("Qatar",'Middle East',11437,628000,null);
INSERT INTO bbc VALUES ("Republic of Congo",'Africa',342000,3039126,null);
INSERT INTO bbc VALUES ("Romania",'Europe',238391,22200000,64824000000);
INSERT INTO bbc VALUES ("Russia",'Europe',17000000,141500000,4.82515E+11);
INSERT INTO bbc VALUES ("Rwanda",'Africa',26338,8600000,1892000000);
INSERT INTO bbc VALUES ("Samoa",'Asia-Pacific',2831,182000,null);
INSERT INTO bbc VALUES ("San Marino",'Europe',61,27000,null);
INSERT INTO bbc VALUES ("Sao Tome and Principe",'Africa',1001,169000,62530000);
INSERT INTO bbc VALUES ("Saudi Arabia",'Middle East',2240000,25600000,2.67008E+11);
INSERT INTO bbc VALUES ("Senegal",'Africa',196722,10600000,7102000000);
INSERT INTO bbc VALUES ("Serbia and Montenegro",'Europe',102173,10500000,27510000000);
INSERT INTO bbc VALUES ("Seychelles",'Africa',455,76000,null);
INSERT INTO bbc VALUES ("Sierra Leone",'Africa',71740,5300000,1060000000);
INSERT INTO bbc VALUES ("Singapore",'Asia-Pacific',660,4400000,1.06568E+11);
INSERT INTO bbc VALUES ("Slovakia",'Europe',49033,5400000,34992000000);
INSERT INTO bbc VALUES ("Slovenia",'Europe',20273,2000000,29620000000);
INSERT INTO bbc VALUES ("Solomon Islands",'Asia-Pacific',27556,504000,277200000);
INSERT INTO bbc VALUES ("Somalia",'Africa',637657,10700000,null);
INSERT INTO bbc VALUES ("South Africa",'Africa',1220000,45300000,1.64439E+11);
INSERT INTO bbc VALUES ("South Korea",'Asia-Pacific',99313,48200000,6.73836E+11);
INSERT INTO bbc VALUES ("Spain",'Europe',505988,44100000,9.35361E+11);
INSERT INTO bbc VALUES ("Sri Lanka",'South Asia',65610,19400000,19594000000);
INSERT INTO bbc VALUES ("St Kitts and Nevis",'Americas',269,46000,null);
INSERT INTO bbc VALUES ("St Lucia",'Americas',616,152000,655120000);
INSERT INTO bbc VALUES ("St Vincent and the Grenadines",'Americas',389,121000,441650000);
INSERT INTO bbc VALUES ("Sudan",'Middle East',2500000,35000000,18550000000);
INSERT INTO bbc VALUES ("Surinam",'South America',163265,442000,null);
INSERT INTO bbc VALUES ("Swaziland",'Africa',17364,1100000,1826000000);
INSERT INTO bbc VALUES ("Sweden",'Europe',449964,8900000,3.18353E+11);
INSERT INTO bbc VALUES ("Switzerland",'Europe',41284,7100000,3.42433E+11);
INSERT INTO bbc VALUES ("Syria",'Middle East',185180,18600000,22134000000);
INSERT INTO bbc VALUES ("Taiwan",'Asia-Pacific',36188,22700000,3.02364E+11);
INSERT INTO bbc VALUES ("Tajikistan",'Asia-Pacific',143100,6300000,null);
INSERT INTO bbc VALUES ("Tanzania",'Africa',945087,38400000,null);
INSERT INTO bbc VALUES ("Thailand",'Asia-Pacific',513115,64100000,1.62814E+11);
INSERT INTO bbc VALUES ("The Gambia",'Africa',11295,1500000,null);
INSERT INTO bbc VALUES ("The Maldives",'South Asia',298,338000,848380000);
INSERT INTO bbc VALUES ("The Netherlands",'Europe',41864,16300000,5.1671E+11);
INSERT INTO bbc VALUES ("The Philippines",'Asia-Pacific',300000,82800000,96876000000);
INSERT INTO bbc VALUES ("Togo",'Africa',56785,5100000,1938000000);
INSERT INTO bbc VALUES ("Tonga",'Asia-Pacific',748,106000,null);
INSERT INTO bbc VALUES ("Trinidad and Tobago",'Americas',5128,1300000,null);
INSERT INTO bbc VALUES ("Tunisia",'Middle East',164150,10000000,26300000000);
INSERT INTO bbc VALUES ("Turkey",'Europe',779452,73300000,2.74875E+11);
INSERT INTO bbc VALUES ("Turkmenistan",'Asia-Pacific',488100,5000000,null);
INSERT INTO bbc VALUES ("Tuvalu",'Asia-Pacific',26,10000,null);
INSERT INTO bbc VALUES ("Uganda",'Africa',241038,27600000,7452000000);
INSERT INTO bbc VALUES ("Ukraine",'Europe',603700,47800000,60228000000);
INSERT INTO bbc VALUES ("United Arab Emirates",'Middle East',77700,3100000,null);
INSERT INTO bbc VALUES ("United Kingdom",'Europe',242514,59600000,2.02282E+12);
INSERT INTO bbc VALUES ("United States of America",'North America',9800000,295000000,1.2213E+13);
INSERT INTO bbc VALUES ("Uruguay",'South America',176215,3500000,null);
INSERT INTO bbc VALUES ("Uzbekistan",'Asia-Pacific',447400,26900000,null);
INSERT INTO bbc VALUES ("Vanuatu",'Asia-Pacific',12190,222000,297480000);
INSERT INTO bbc VALUES ("Vatican",'Europe',0,null,null);
INSERT INTO bbc VALUES ("Venezuela",'South America',881050,26600000,null);
INSERT INTO bbc VALUES ("Vietnam",'Asia-Pacific',329247,83600000,45980000000);
INSERT INTO bbc VALUES ("Yemen",'Middle East',536869,21500000,12255000000);
INSERT INTO bbc VALUES ("Zambia",'Africa',752614,11000000,4950000000);
INSERT INTO bbc VALUES ("Zimbabwe",'Africa',390759,12900000,6192000000);