Practice · Defence · Medium

The European supplier bloc

Return one column named european_share holding the combined share_pct of Germany, Italy and France.

Runs in your browser. No signup needed.

What you are given

arms_imports(supplier, share_pct). SUM the three named European suppliers with WHERE ... IN (...).

Starting point

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.

Did you know

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)

More Defence challenges

Open it in the playground →