When I use the syntax:
=query(Clients!A:J,"select H where (H='Yes')",-1)
I only get "Assigned" as a result, no # of records.
=query(Clients!A:J,"select H where H contains 'Yes'",-1)
More of a syntax error.
= checks whether it is exactly equal and might contain errors.
contains should do the trick.