Where the water goes

What you are given

water_use(sector, share_pct).

Starting point

SELECT sector, share_pct
FROM water_use
ORDER BY share_pct DESC;

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.

Did you know

Agriculture takes ~86% of Egypt’s water while the country sits well below the international water-scarcity line — which is why every drainage drop is now recycled. (FAO AQUASTAT)

More Water challenges

• The thirstiest sector Easy

Open it in the playground →