Primero creamos una vista base:
create view country_payment as select country, payment.* from country join city using (country_id) join address using (city_id) join customer using (address_id) join payment using (customer_id)
Después nos basamos en esta para crear las siguientes:
create view country_total as select country, sum(amount) total from country_payment group by country create view country_month as select country, month(payment_date) month, count(payment_id) total from country_payment group by country, month