Count computers with a specific filename Collection based

Count computers with a specific filename Collection based:

select SF.FileName, SF.FileDescription, SF.FileVersion, count(distinct SF.ResourceID) as 'Count', FCM.CollectionIDfrom v_GS_SoftwareFile SF JOIN v_FullCollectionMembership FCM ON SF.ResourceID = FCM.ResourceID where SF.FileName Like @variable and FCM.CollectionID=@CollIDGroup By FCM.CollectionID, SF.FileName, SF.FileDescription, SF.FileVersion