SQLZOO--SUM and COUNT--分类统计

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

SELECT continent,COUNT(*) FROM world WHERE continent IN (

      SELECT DISTINCT continent from world)

     AND population>=10000000 

     GROUP BY continent;

注意：COUNT必须配合GROUP BY才合法。