[MySQL] Revising Aggregations - The Count Function

▶  SQL  >  Aggregation  > Revising Aggregations - The Count Function 

 Problem 

Query a count of the number of cities in CITY having a Population larger than 100,000.

Input Format

The CITY table is described as follows: 

 

 My Answer 

SELECT COUNT(*)
FROM CITY
WHERE POPULATION > 100000