Age Report of pending tickets of particular support group

Age Report of pending tickets of particular support group

Can someone help me to get the query to generate the report of all pending tickets of specific group along with the age of ticket and  report with number of tickets in different priority  like below

Priority 0-14 days 15-30 days 30-45 days 45- 60 days More than 60 days
Critical          
High          
Mediam          
Low          

Ticket ID Technician  Requester  Status Age
         
         
         

      New to ADSelfService Plus?

        Resources

                  Related Products