Modify report: avg. time spend to close ticket

Modify report: avg. time spend to close ticket

I've got a report, avg. time spend to close a ticket by group
  1. SELECT MAX(qd.QUEUENAME) "Group", MAX(pd.PRIORITYNAME) "Priority", TO_CHAR(((AVG(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "AVG Time Elapsed", TO_CHAR(((SUM(wo.TIMESPENTONREQ))/1000 || ' second')::interval, 'HH24:MI:SS') "Total Time Elapsed" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID WHERE (wo.ISPARENT='1') AND wo.completedtime>= <from_lastmonth> AND wo.completedtime<= <to_lastmonth> AND qd.QUEUENAME in( 'Системный администратор', 'РК Специалист') GROUP BY pd.PRIORITYID, qd.QUEUEID ORDER BY 1
I need modify it, exclude tickets with SLA violation, because 1 ticket with SLA violation can change all statistics to a tech group ;((
What should I modify in this query?

SDP 8217

                  New to ADSelfService Plus?