Revising-Aggregations-The-Count-Function.sql

-- Revising Aggregations The Count Function
-- Query a count of the number of cities in CITY having a Population larger than 100,000.
select count(name) from city where population > 100000;