SELECT ti.FIRST_NAME "Technician", count(wo.WORKORDERID) "Total Request",count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) "Completed Requests" , count(case when (std.ISPENDING='0' AND wos.ISOVERDUE='1') THEN 1 ELSE NULL END) "SLA violated", count(case when (std.ISPENDING='0' AND wos.ISOVERDUE='0') THEN 1 ELSE NULL END) "SLA not violated" ,case when count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) =0 THEN NULL ELSE count(case when (std.ISPENDING='0' AND wos.ISOVERDUE='1') THEN 1 ELSE NULL END) *100 /count(case when std.ISPENDING='0' THEN 1 ELSE NULL END) END "% Violated" FROM WorkOrder wo LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std on wos.statusid=std.statusid LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID 

 WHERE (wo.ISPARENT='1') GROUP BY  ti.FIRST_NAME