select 
Opportunity__r.Country_of_Ownership__c, 
CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c)Vmonth, 
 COUNT_DISTINCT(Opportunity__r.Id) Volume 
 
from Transaction_Allocation__c
 
where 
(
  Transaction_Allocation__c.Stage__c IN ('Posted','Refunded','Failed','Refund','Reversal')
 
AND
  
     (Transaction_Allocation__c.Close_Date__c  > 2022-03-31 AND                Transaction_Allocation__c.Close_Date__c  < NEXT_N_DAYS:1) 
 
AND
   
 Opportunity__r.RecordTypeId IN ('012w00000006jGy','0122X000000ie1A')

AND Opportunity__r.Date_Recurring_Donation_Established__c > 2022-03-31)
 
  
Group by 
Opportunity__r.Country_of_Ownership__c ,
  CALENDAR_MONTH(Transaction_Allocation__c.Close_Date__c)