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

❓ Question
https://www.hackerrank.com/challenges/revising-aggregations-the-count-function

Revising Aggregations - The Count Function | HackerRank

❗ Answer

SELECT COUNT(name)
    FROM city
    WHERE population > 100000;

📌 Discussion

• where에서 조건문을 걸어주고 count로 집계