SQLZOO 5 sum and count

1.Show the total population of the world.

显示世界总人口。

select sum(population) from world

2.List all the continents - just once each.

列出所有的大洲——每个大洲只列一次。

select continent from world group by continent

3.Give the total GDP of Africa

给出非洲的GDP总量

select sum(gdp) from world where continent='Africa'

4.How many countries have an area of at least 1000000

有多少国家的国土面积超过100万

select count(name) from world where area>=1000000

5.What is the total population of (‘Estonia’, ‘Latvia’, ‘Lithuania’)

爱沙尼亚、拉脱维亚、立陶宛的总人口是多少?

select sum(population) from world where name in ('Estonia','Latvia','Lithuania') 

6.For each continent show the continent and number of countries.

对于每个大陆显示大陆和国家数量。

select continent,count(name)  from world group by continent

7.For each continent show the continent and number of countries with populations of at least 10 million.

对于每个大陆，请显示人口至少1000万的大陆和国家数量。

select continent,count(name) from world where population >= 10000000 group by continent

8.List the continents that have a total population of at least 100 million.

列出人口总数超过1亿的大洲。

select continent from world group by continent having sum(population)>=100000000

这次的主题是sum、count、group by、having的结合使用，没什么好说的，写的少了用不习惯，练习量还需要增加。