Practice · Demographics · Easy

The most populous governorates

Return the name and population_millions of governorates with more than 6 million people, most populous first.

Runs in your browser. No signup needed.

What you are given

governorates(name, population_millions, area_km2).

Starting point

SELECT name, population_millions
FROM governorates
WHERE ...
ORDER BY ...;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row, and order matters for this one.

Did you know

Over 95% of Egyptians live on ~4% of the land — the Nile Valley and Delta. Cairo and Giza alone hold ~20 million people. (CAPMAS)

More Demographics challenges

Population density Medium
Egypt’s total population Easy
Bigger than average Hard
Egypt since the millennium Easy
The three biggest governorates Easy

Open it in the playground →