[hackerrank] Revising Aggregations - The Count Function

[hackerrank] Prepare > SQL > Aggregation >  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: 

[MYSQL]

 

 

[ORCALE]

select count(*)
from city
where population > 100000;