geo_sales (sale_id, customer_id, region, country, amount) holds one row per sale.
Return one row per country with its revenue (the sum of amount) and two shares, each a percentage rounded to 1 decimal place:
- •
pct_of_region — the country's revenue as a share of its region's revenue; - •
pct_of_total — the country's revenue as a share of all revenue.
Columns: region, country, revenue, pct_of_region, pct_of_total. Sort by region, then country.