Total value of top exports

What you are given

Use exports. SUM the value_usd_bn column.

Starting point

SELECT SUM(value_usd_bn) AS total_usd_bn
FROM exports;

The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.

Did you know

These five categories are only Egypt’s TOP exports, not all of them — the country also earns heavily from services like the Suez Canal and tourism, which aren’t “goods”. (Coface)

More Economy challenges

• Big export earners Easy
• GDP, year by year Medium
• Year-over-year GDP change (window function) Hard
• The high-inflation years Medium
• Peak GDP year Medium

Open it in the playground →