Revising Aggregations - The Count Function :- HackerRank SQL Solution in MYSQL

Problem:-

Query a count of the number of cities in CITY having a Population larger than .

Input Format

The CITY table is described as follows:

Solution:-

SELECT COUNT(*)
FROM City

WHERE Population > 100000;