Revising-Aggregations-The-Count-Function.sql

SELECT COUNT(NAME) FROM CITY
WHERE POPULATION > 100000;