Practice · Economy · Easy
Return the export categories that make up more than 5% of total exports, as category and pct_of_total, largest share first.
Runs in your browser. No signup needed.
exports(category, value_usd_bn, pct_of_total).
SELECT category, pct_of_total
FROM exports
WHERE ...
ORDER BY ...;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.
Petroleum & electricity alone are ~33% of Egypt’s goods exports; textiles built on long-staple Egyptian cotton follow. (Lloyds Bank / Coface trade profile)