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
SELECT region, COUNT(name) FROM bbc
WHERE population >= 10000000
GROUP BY region
SELECT region FROM bbc
GROUP BY region
HAVING SUM(population) >= 100000000