HAVINGWHERE, GROUP BY的使用

HAVING / WHERE, GROUP BY的使用： SELECT region, COUNT(name) FROM bbc WHERE population >= 10000000 GROUP BY region SELECT region FROM bbc GROUP BY region HAVING SUM(population) >= 100000000