[해커랭크/SQL] 22. Revising Aggregations - The Count Function

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

Revising Aggregations - The Count Function | HackerRank

---

 

🤔 문제 분석

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

 

💡 풀이

SELECT COUNT(DISTINCT NAME)
FROM CITY
WHERE POPULATION > 100000