Practice · Economy · Easy

The inflation spikes

Return the year and rate_pct for every year where annual inflation was above 20%, oldest first.

Runs in your browser. No signup needed.

What you are given

inflation(year, rate_pct). Filter WHERE rate_pct > 20, then ORDER BY year.

Starting point

SELECT year, rate_pct
FROM inflation
WHERE rate_pct > ...
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 saw inflation spike after the 2016 pound float and again in 2023–24 — annual rates topped 30%. (World Bank / CBE, annual averages)

More Economy challenges

Big export earners Easy
GDP, year by year Medium
Year-over-year GDP change (window function) Hard
Total value of top exports Easy
The high-inflation years Medium

Open it in the playground →