[해커랭크(Hacker Rank)]Revising Aggregations - The Count Function (MySQL)

문제

Query a count of the number of cities in CITY having a Population larger than .
Input Format
The CITY table is described as follows: 

 

코드

SELECT COUNT(*)
FROM city
WHERE population > 100000

 

풀이

1. pupulation이 100000 초과

 

출처