[MySQL/HackerRank] Revising Aggregations - The Count Function

https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem?isFullScreen=true 

Revising Aggregations - The Count Function | HackerRank

문제

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

Input Format

The CITY table is described as follows: 

Code

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