I don't know if it helps but here is the actual code I was trying to use

Select Resource_Domain_OR_Workgr0,

(Select count (distinct Name0) WHERE (Operating_System_Name_and0 LIKE '%Server%' AND Client0 = 1))...