3 Months rolling query

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 ...