SELECT wo.WORKORDERID "Request ID", 

max(wo.TITLE) "Subject", 

max(ti.FIRST_NAME) "Technician", 

max(std.STATUSNAME) "Request Status", 

max(tech.first_name) "Due by Technician", 

max(g.queuename) "Due by Group" FROM WorkOrder wo 

LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID 

LEFT JOIN SDUser td ON wos.OWNERID=td.USERID 

LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID 

LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID 

LEFT JOIN (select woh1.workorderid, ti1.first_name from workorderhistory woh1 left join workorderhistorydiff wohd1 on woh1.historyid=wohd1.historyid left join aaauser ti1 on cast(cast(wohd1.prev_value as varchar) as int)=ti1.user_id left join workorder wo1 on wo1.workorderid=woh1.workorderid where cast(wohd1.COLUMNNAME as nvarchar) in ('OWNERID') and woh1.operationtime > wo1.duebytime) tech on wo.workorderid=tech.workorderid 

LEFT JOIN (select woh2.workorderid, qd2.queuename from workorderhistory woh2 left join workorderhistorydiff wohd2 on woh2.historyid=wohd2.historyid left join queuedefinition qd2 on cast(cast(wohd2.prev_value as varchar) as int)=qd2.queueid left join workorder wo2 on wo2.workorderid=woh2.workorderid where cast(wohd2.COLUMNNAME as nvarchar) in ('QUEUEID') and woh2.operationtime > wo2.duebytime) g on wo.workorderid=g.workorderid where wos.isoverdue=1and ("wo"."COMPLETEDTIME" >= <from_lastweek> AND "wo"."COMPLETEDTIME" <= <to_lastweek>) group by wo.WORKORDERID

ORDER BY "Due By Group"

However, I would like to add information about how long the request was assigned to all groups who, at some point, handeld the ticket/request.