Practice · Suez Canal · Medium
Return the average Suez Canal revenue across all years EXCEPT the 2024 crisis year, as avg_rev, rounded to 2 decimals.
Runs in your browser. No signup needed.
Use suez. Exclude year 2024 with a WHERE, then AVG(revenue_usd_bn).
SELECT ROUND(AVG(revenue_usd_bn), 2) AS avg_rev
FROM suez
WHERE year <> 2024;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
Even a single crisis year drags an average down sharply — which is why analysts often report medians or exclude known shocks when summarising volatile revenue. (methodology)