本文展示了如何使用SQL查询从数据库中获取世界人口总数、列出所有不同的大陆、计算非洲的总GDP、找出面积超过1000000平方公里的国家数量、获取指定国家的人口总数、按大陆统计国家数量以及筛选出人口超过1000万的国家所在大陆。这些查询涵盖了SQL的基础操作，如聚合函数SUM、COUNT、DISTINCT以及WHERE和GROUP BY子句。
Part 5：SUM and COUNT
world
1. Show the total population of the world.
SELECT SUM(population)
FROM world2. List all the continents - just once each.
SELECT DISTINCT continent
FROM world3. 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.
SELECT COUNT(name)
FROM world
WHERE area >= 10000005. 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 continent7. For each continent show the continent and number of countries with populations of at least 10 million.
SELECT continent,COUNT(name)
FROM world
WHERE population>=10000000
GROUP BY continent8. List the continents that have a total population of at least 100 million.
SELECT continent FROM world GROUP BY continent HAVING SUM(population)>=100000000
扫一扫
115
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
