공부/PS ( SQL)
[HackerRank/Aggregation] Revising Aggregations - The Count Function
happyst
2022. 5. 17. 01:19
https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem
Revising Aggregations - The Count Function | HackerRank
Query the number of cities having populations larger than 100000.
www.hackerrank.com
문제
풀이
SELECT COUNT(NAME) FROM CITY
WHERE POPULATION > 100000