Custom Reports - Help!

Hi,

Can anyone give me the SQL code for generating the following reports:

- Total number of requests raised for previous month
- Total number of requests closed for previous month
- Request turnaround times (e.g. number of requests resolved same day, next day, 2 days, etc)

I have tried manipulating the provided reports with varying degrees of success.

Thanks in advance.