1:展示世界的總人口。
SELECT SUM(population) FROM world;
2:列出所有的洲份, 每個只有一次。
SELECT DISTINCT continent FROM world;
3:找出非洲(Africa)的GDP總和。
SELECT SUM(gdp) FROM world WHERE continent = 'Africa';
4:有多少個國家具有至少百萬(1000000)的面積。
SELECT COUNT(name) FROM world WHERE area>=1000000;
5:('France','Germany','Spain')(“法國”,“德國”,“西班牙”)的總人口是多少?
SELECT SUM(population) FROM world WHERE name IN ('France','Germany','Spain');
6:For each continent show the continent