Hello coders, today we are going to solve Revising Aggregations – The Count Function HackerRank Solution in SQL.
Query a count of the number of cities in CITY having a Population larger than 100,000.
The CITY table is described as follows:
Solution – Revising Aggregations – The Count Function in SQL
SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000
Disclaimer: The above Problem (Revising Aggregations – The Count Function) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.