Automatically running a query for unresolved posts and sending the results as an email

I have a query which I can run and collect all the topics which have not been marked as solved (unresolved) within the past month.

Does anyone know how I can automate this to happen every week and then send the list of queries directly to an email inbox as a notification?

Maybe have a look at this: Automatically email admin report CSVs on a recurring cadence - #3 by sam