Practice · Water · Easy
Return the single sector that uses the largest share of Egypt’s water, with its share_pct.
Runs in your browser. No signup needed.
Use water_use. ORDER BY share_pct descending, LIMIT 1.
SELECT sector, share_pct
FROM water_use
ORDER BY share_pct DESC
LIMIT 1;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.
Agriculture’s ~86% share is why Egypt’s water strategy focuses on farming — canal lining, drip irrigation and treating drainage water all target that single sector. (FAO / Ministry of Water Resources)