Practice · Defence · Medium
Return one column named european_share holding the combined share_pct of Germany, Italy and France.
Runs in your browser. No signup needed.
arms_imports(supplier, share_pct). SUM the three named European suppliers with WHERE ... IN (...).
SELECT SUM(share_pct) AS european_share
FROM arms_imports
WHERE supplier IN (...);
The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
Germany, Italy and France together supplied about 78% of Egypt’s arms imports in 2020–2024, while overall import volume fell ~44% versus the previous five years. (SIPRI, 2025)