Total wheat on record

What you are given

crops(crop, year, million_tonnes). SUM(...) with WHERE crop = ‘Wheat’, wrapped in ROUND(…, 2).

Starting point

SELECT ROUND(SUM(million_tonnes), 2) AS total_mt
FROM crops
WHERE crop = 'Wheat';

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

Did you know

Egypt grows ~9 million tonnes of wheat a year yet is still the world’s largest wheat importer — it can’t grow enough for 116 million people. (FAOSTAT)

More Agriculture challenges

• Which crops do we track? Easy
• Average output per crop Medium
• Total staple output per year Medium
• Above-average harvest years (CTE) Hard
• Each crop’s best year (correlated) Hard

Open it in the playground →