Revenue by Country

Write a query returning country and revenue (sum of order totals) for every country that has at least one order, sorted by revenue descending.

Schema

customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)