The key to doing reports over periods of time is to utilize the
aggregate and functions in conjunction with
GROUP BY
Please note that I have not formatted this for any particular version of SQL, and I also do not not know what column in your table contains the amounts of sale. You may need to adjust for your situation
SELECT YEAR(sale_date_paid), MONTH(sale_date_paid), SUM(OrderTotal)
FROM sales
GROUP BY YEAR(sale_date_paid), MONTH(sale_date_paid)
ORDER BY YEAR(sale_date_paid), MONTH(sale_date_paid)
Reference: MySQL sum() with group by - w3resource[^]