Hackerrank - Revising Aggregations - The Count Function solution

Problem link

Solution one:

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