overall summery report by company

hi ,

I'm looking for the same query for each company ..
version : 9.3 Build 9334

thanks

SELECT count(wo.workorderid) "Total",
count(case when std.statusname='Assigned' THEN 1 ELSE NULL END) "Assigned",
count(case when std.statusname='Resolved' THEN 1 ELSE NULL END) "Resolved",
count(case when std.ISPENDING='1' THEN 1 ELSE NULL END) "Pending Requests" ,
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 Met" ,
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 "SLA Violation %" FROM WorkOrder wo
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN StatusDefinition std on wos.statusid=std.statusid
LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID
WHERE wo.ISPARENT='1' AND
dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (wo.CREATEDTIME/1000),'1970-01-01 00:00:00') >= convert(varchar,'2016-01-01 00:00',21)