Hackerrank - Revising Aggregations - The Count Function solution

Solution one:

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