Revising Aggregations - The Count Function

AGGREGATION

Question Link

Query a count of the number of cities in CITY having a Population larger than 100000.

Input Format

The CITY table is described as follows:

SELECT COUNT(name)
FROM City
WHERE population > 100000