[해커랭크] Revising Aggregations - The Count Function

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

 

❓문제

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

(인구가 100,000명보다 많은 CITY 수 출력)

Input Format

The CITY table is described as follows: 

 

❗답

SELECT COUNT(*)
FROM CITY
WHERE POPULATION > 100000

 

---

🤔풀이

count: 개수 출력