Practice · Tourism · Easy
Return the year and revenue_usd_bn for every year where tourism revenue is recorded (not NULL), earliest first.
Runs in your browser. No signup needed.
tourism(year, arrivals_millions, revenue_usd_bn). Some years have a NULL revenue.
SELECT year, revenue_usd_bn
FROM tourism
WHERE revenue_usd_bn IS NOT NULL
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.
2021 revenue is deliberately blank — official sources genuinely disagree on the figure, so the KB records NULL rather than guessing. (Ministry of Tourism / CBE)