网址:https://sqlzoo.net/wiki/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 DISTINCT continent
FROM world
3、Give the total GDP of Africa
给出非洲的国内生产总值。
SELECT SUM(gdp)
FROM world
WHERE continent = 'Africa'
4、How many countries have an area of at least 1000000
有多少国家面积至少为 1000000。
SELECT COUNT(name)
FROM world
WHERE area >= 1000000
5、What is the total population of ('Estonia', 'Latvia', 'Lithuania')
'Estonia', 'L