Anusha Murali

Logo

Please see github.com/anusha-murali for all of my repositories.

View GitHub Profile

9. Revising Aggregations - The COUNT Function: Solution


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

The CITY table is described as follows:

1

solution_image5

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

Back to problems


anusha-murali.github.io