Well, you could if you wanted to, but that, to me, seems extra work. Unless there is a complaint, is it really necessary to check regularly? Alternatively, a cron job set to run the SQL automatically would be a better option, I suspect. Set the cron to, say, run on the 25th of each month to collect data from 25th of the previous month to to the 24th of the current month. How that could be done.... no idea on establishing the date math in an SQL string.
I would agree there should be a simpler way, say an ad hoc report or perhaps a report generator plugin of some description, which would be better. Perhaps there is one in plugins, maybe.