Practice · Suez Canal · Easy
Return year and revenue_usd_bn from the suez table, highest revenue first, so the 2024 collapse sits at the bottom.
Runs in your browser. No signup needed.
suez(year, revenue_usd_bn, note).
SELECT year, revenue_usd_bn
FROM suez
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.
Suez revenue fell ~61% to ~$3.99bn in 2024 as Red Sea attacks cut traffic ~90% — Egypt’s single largest hard-currency shock in years. (Suez Canal Authority)