Practice · Tourism · Medium
Return the increase in international arrivals from 2023 to 2025, in millions, as growth_millions.
Runs in your browser. No signup needed.
Use tourism. Subtract the 2023 arrivals from the 2025 arrivals with two subqueries.
SELECT (SELECT arrivals_millions FROM tourism WHERE year=2025)
- (SELECT arrivals_millions FROM tourism WHERE year=2023) AS growth_millions;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
Egypt added ~4 million annual visitors in two years to hit a record ~19M in 2025 — tourism is one of its top hard-currency earners alongside the Suez Canal and remittances. (SIS)