列出总人口至少一亿的大洲。
World Table name continent area population gdp Afghanistan Asia 652230 25500100 20343000000 Albania Europe 28748 2831741 12960000000 Algeria Africa 2381741 37100000 188681000000 Andorra Europe 468 78115 3712000000 Angola Africa 1246700 20609294 10009000990 ... ...
我开始
SELECT continent FROM world WHERE ... 有点卡在这里。
SELECT continent FROM world WHERE ...
不知道如何利用GROUP BY和SUM。我需要GROUP BY continent和 SUM(population)一些如何，但我仍然在学习如何把东西放在一起。
GROUP BY continent
SUM(population)
预期产量
continent Africa Asia Eurasia Europe North America South America
SELECT continent, SUM(population) FROM world GROUP BY continent HAVING SUM(population) >= 100000000
