For each country with customers, return country, customers, revenue (0 if no orders), customer_rank and revenue_rank (both RANK, highest first). Sort by revenue_rank, then country.
Schema
customers(id, name, country, signup_date)
orders(id, customer_id, order_date, total)