01. Revising Aggregations - The Count Function.sql

--Problem: https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem

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