3 Months rolling query

Copper Contributor

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




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