01 - Revising Aggregations - The Count Function.sql

-- ========================
--       Information
-- ========================

-- Direct Link: https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem
-- Difficulty: Easy
-- Max Score: 10
-- DBMS: mySQL

-- ========================
--         Solution
-- ========================

SELECT COUNT(*)
FROM CITY
WHERE POPULATION > 100000;