The three biggest governorates

What you are given

governorates(name, population_millions, area_km2). ORDER BY … DESC then LIMIT 3.

Starting point

SELECT name, population_millions
FROM governorates
ORDER BY population_millions DESC
LIMIT 3;

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

Cairo and Giza together hold a huge share of Egypt’s people — the Nile has always concentrated life onto a thin ribbon of land. (CAPMAS)

More Demographics challenges

• The most populous governorates Easy
• Population density Medium
• Egypt’s total population Easy
• Bigger than average Hard
• Egypt since the millennium Easy

Open it in the playground →