Query a count of the number of cities in CITY having a Population larger than 100000
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
