Practice · Industry · Easy
Return the combined headline value of all the investment deals, as total_usd_bn.
Runs in your browser. No signup needed.
Use investment_deals. SUM the value_usd_bn column.
SELECT SUM(value_usd_bn) AS total_usd_bn
FROM investment_deals;The reference solution is checked automatically when you run your query on the practice page — results are compared row by row.
Beware double-counting headline figures: the IMF and Ras El Hekma sums measure very different things (a loan facility vs. a foreign direct investment), so adding them is illustrative, not an economic total. (IMF / Bloomberg)