Trying to group records by month to get totals for each month

what is the most efficient way to get wappler to do this in the query builder? I have an events table which lists events by date with the amount collected for the event. I simply want to write a query to give me the total amounts collected for each month of the year. Should I use a While function to loop over months and somehow create a query with the date being fed by the number of the month? Should I use a SQL function to group by month but I would have to use the custom query builder.? Trying to see if I’m missing a simple way to do this within the current wappler functionality. Thanks for any advice!
Rick