Exclude Tech From Query Report

Hi All,

looking forward to your valuable help to instruct about how to exclude specific technician from a query report that i generate it using "MSSQL" to get the status of mainly violated tickets. The following is the current query: and if possible write down the clause that i should follow for excluding whether tech or certain group. Thanks in advance.

SELECT MAX(ti.FIRST_NAME) "Technician",

count(case when std.STATUSNAME='Open' THEN 1 ELSE NULL END) "Open Requests",

count(case when std.STATUSNAME='OnHold' THEN 1 ELSE NULL END) "OnHold Requests",

count(case when (wos.ISOVERDUE='1' and std.ispending='1') THEN 1 ELSE NULL END) "Overdue Requests" 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 WHERE (wo.ISPARENT='1') GROUP BY ti.USER_ID