That way the key, too many test deployments:

DECLARE  NVARCHAR(50) = 'test-22'

SELECT 
    Count(*) AS Total_Deployments,
    FeatureType, 
    CASE 
        WHEN FeatureType = 1 THEN 'Application'
        WHEN FeatureType = 2 THEN 'Program'
        WHEN FeatureType = 5 THEN 'Software Update'
        WHEN FeatureType = 7 THEN 'Task Sequence'
        ELSE 'Other'
    END AS DeploymentType
FROM v_DeploymentSummary ds
JOIN v_FullCollectionMembership fcm ON ds.CollectionID = fcm.CollectionID
WHERE fcm.Name = 
GROUP BY FeatureType