SQL query to define technicians aged report
Hello
Could someone please help me with a sql query to report all technicians and aged ticket. similar to the below (but rather than group, would like technicians)
Technicians name Total Pending Count
0 - 2 Days 2 - 5 Days 5 - 10 Days 10 - 15 Days 15 - 30 Days More than 30 Days
Technician ID 1
Technician ID 2 34 0 0 0 0 0 34
Technician ID 3 31 1 0 0 0 2 28
Could someone please help me with a sql query to report all technicians and aged ticket. similar to the below (but rather than group, would like technicians)
Technicians name Total Pending Count
0 - 2 Days 2 - 5 Days 5 - 10 Days 10 - 15 Days 15 - 30 Days More than 30 Days
Technician ID 1
Technician ID 2 34 0 0 0 0 0 34
Technician ID 3 31 1 0 0 0 2 28