第六章 聚合函数分组

关键字 COUNT 统计行和列、AVG求平均值、SUM求和、MAX求最大数、MIN求最小的数

 

练习：

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

-- 1.获得和'brazil'（巴西）同性一个地区的所有国家
SELECT NAME FROM bbc WHERE region = (SELECT region FROM bbc WHERE NAME = 'brazil')

-- 2.给出人口多于'russia'（俄罗斯）的国家名称
SELECT NAME FROM bbc WHERE population > (SELECT population FROM bbc WHERE NAME =  'russia')

-- 3.给出'india'（印度），‘iran’所在地区的所有国家的所有信息
SELECT * FROM bbc WHERE region = (SELECT region FROM bbc WHERE NAME = 'india') OR region = (SELECT region FROM bbc WHERE NAME = 'iran')

-- 4.给出人均GDP超过'united kingdom'(英国)的欧洲国家
SELECT * FROM bbc WHERE gdp/population > (SELECT gdp/population FROM bbc WHERE NAME = 'united kingdom') AND region = 'europe'

-- 5.给出人口比canada(加拿大)多但少于‘algeria’(阿尔及利亚)的国家的信息
SELECT NAME FROM bbc WHERE population BETWEEN (SELECT population FROM bbc WHERE NAME = 'canada') AND (SELECT population FROM bbc WHERE NAME = 'algeria')

-- 6.给出GDP比任何欧洲国家都多的国家（只显示国家名称）
SELECT NAME FROM bbc WHERE gdp > (SELECT MAX(gdp) FROM bbc WHERE region = 'europe')

-- 7.给出每个地区人口最大的国家
SELECT NAME FROM bbc WHERE population IN (SELECT MAX(population) FROM bbc GROUP BY region);

-- 8.给出地区中所有国家的人口总数为0的地区
SELECT region FROM bbc GROUP BY region HAVING SUM(population) = 0

-- 9.有些国家的人口数比它的周边国家（周边国家指在同一地区的国家）要多三倍，列出这些国家和地区
SELECT NAME,region FROM bbc WHERE population IN(SELECT population FROM bbc GROUP BY region,NAME)