Rates between two years (BETWEEN)

What you are given

exchange_rate(year, egp_per_usd). Use WHERE year BETWEEN 2020 AND 2023.

Starting point

SELECT year, egp_per_usd
FROM exchange_rate
WHERE year BETWEEN ... AND ...
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

The pound went from ~16 to the dollar in 2020 to ~50 by 2024 across successive devaluations. (CBE / market rates, approximate year-end)

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 →