Revising Aggregations - The Count Function
- URL : https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem
- Query a count of the number of cities in CITY having a Population larger than 100,000.
- MySQL, Oracle Solution
1
2
3
select count(name)
from city
where population >= 100000;