Need help generating a report of all the tickets created in the past month.

We are looking to create a report of ALL the tickets that were created in the past month for a specific queue.

We have tried the reports in Kace, but was not able to achieve a report that only shows the tickets created in the past month.

Using the wizard, we got a report that we wanted, but it shows all the tickets from the beginning and not the past month, maybe someone can help in editing this sql query so that it only shows the tickets created in the past month.