3 Months rolling query

%3CLINGO-SUB%20id%3D%22lingo-sub-2954493%22%20slang%3D%22en-US%22%3E3%20Months%20rolling%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2954493%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Customer%20name%20%2C%20Date%20%2C%20ticket_id%20.%20I%20need%20rolling%20average%26nbsp%3B%20of%20tickets%20for%20each%20customer.%3C%2FP%3E%3CP%3EQuery%20require%20as%26nbsp%3B%3C%2FP%3E%3CP%3E*Month%20over%20Month%3C%2FP%3E%3CP%3E%3CSPAN%3E*Rolling%203%20month%20vs.%20Rolling%203%20month%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E*Current%20month%20over%20same%20month%20last%20year%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETrilok%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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

 

Regards

Trilok

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