3 Months rolling query

[Trilok_Bohra]

I have Customer name , Date , ticket_id . I need rolling average  of tickets for each customer.

Query require as 

*Month over Month

*Rolling 3 month vs. Rolling 3 month 

*Current month over same month last year

Regards

Trilok

[#2]

Please post table design as DDL, some sample data as DML statement and the expechted result.