[SQL][HackerRank] Revising Aggregations - The Count Function

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:

• query count of number of cities ==> SELECT COUNT(ID)
• in CITY table ==> FROM CITY
• Population larger than 100000 ==> WHERE POPULATION > 100000

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