I need a query...

I need a query...

Hi , I need this query :

Tikects open in previous moths | Tickets open in actual Month | Tickets open in every day of actual month |

For example , that's the table that i needed :

                            Previous Mont   |  Actual Month  |  Day 1 | Day 2 | Day 3 | Day 4 | ......
Raised                        80                        7                  4           3 
Closed-Resolved          90                        9                  7           2
Backlog                       70                       7                  3

Thanks in advance.

Alex