Orders by country × status

SELECT c.country, o.status, round(sum(o.total)) AS total
  FROM sample.orders o JOIN sample.customers c ON c.id = o.customer_id
 GROUP BY 1, 2