|| Excellence in Every Line of Code

Revising Aggregations – The Count Function

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

Input Format

The CITY table is described as follows:

Solution Implementation


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

Copied!