Egypt since the millennium

What you are given

population_years(year, population). Use WHERE year >= 2000 and ORDER BY year.

Starting point

SELECT year, population
FROM population_years
WHERE year >= ...
ORDER BY year;

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

Egypt roughly doubled from ~58 million in 1990 to ~116 million by 2024 — one of the fastest large-population growths on Earth. (World Bank)

More Demographics challenges

• The most populous governorates Easy
• Population density Medium
• Egypt’s total population Easy
• Bigger than average Hard
• The three biggest governorates Easy

Open it in the playground →