Practice · Defence · Easy
List each named supplier (exclude the catch-all “Other”) and its share_pct of Egypt’s 2020–2024 arms imports, largest share first.
Runs in your browser. No signup needed.
arms_imports(supplier, share_pct, period). Filter out supplier = ‘Other’, then ORDER BY share_pct descending. Figures are SIPRI shares, not dollar values.
SELECT supplier, share_pct
FROM arms_imports
WHERE supplier <> 'Other'
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.
In 2020–2024 Egypt’s arms imports were European-led — Germany, Italy and France — a shift away from the previously US-heavy mix. All figures are public SIPRI trend-indicator shares. (SIPRI, 2025)