Practice · Defence · Easy

Egypt’s main arms suppliers

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.

What you are given

arms_imports(supplier, share_pct, period). Filter out supplier = ‘Other’, then ORDER BY share_pct descending. Figures are SIPRI shares, not dollar values.

Starting point

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.

Did you know

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)

More Defence challenges

Open it in the playground →