[HackerRank/SQL] Revising Aggregations - The Count Function

Problem. Revising Aggregations - The Count Function

---

Link.

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

Revising Aggregations - The Count Function | HackerRank

---

Description.

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

 

CITY 테이블

---

Key Point. 

SELECT,

 

COUNT,

 

WHERE,

---

My Answer. 

SELECT COUNT(ID)
FROM CITY
WHERE POPULATION > 100000

---

References.