Practice · Suez Canal · Hard

The 2024 drop, in percent

Compute the percentage drop in Suez revenue from 2023 to 2024. Return one row with a single column pct_drop = ROUND((rev2023 − rev2024) / rev2023 × 100, 1). Use subqueries to pull each year’s revenue.

Solve this challenge →

Runs in your browser. No signup needed.

What you are given

suez(year, revenue_usd_bn). Pull 2023 and 2024 with scalar subqueries.

Starting point

SELECT ROUND(
  ( (SELECT revenue_usd_bn FROM suez WHERE year=2023)
  - (SELECT revenue_usd_bn FROM suez WHERE year=2024) )
  / (SELECT revenue_usd_bn FROM suez WHERE year=2023) * 100, 1) AS pct_drop;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.

Did you know

That single number — a ~61% year-on-year collapse — is why the 2024 Suez shock rippled straight into Egypt’s foreign-currency reserves and the IMF programme. (Suez Canal Authority / IMF)

More Suez Canal challenges

Suez revenue, ranked Easy
Average revenue, excluding the crisis Medium

Open it in the playground →