select name,COUNT(id) from vlocity_cmt__OrchestrationItem__c where ((vlocity_cmt__OrchestrationPlanId__r.vlocity_cmt__OrderId__r.MC_SourceSystem__c='Clarity' OR vlocity_cmt__OrchestrationPlanId__r.vlocity_cmt__OrderId__r.MC_SourceSystem__c='ECommerce') AND ( vlocity_cmt__State__c ='Ready' OR vlocity_cmt__State__c = 'Running' ) AND CreatedDate <LAST_N_DAYS:7) AND (Name ='Fiber Installation Completion' OR Name ='SAP Hardware Provisioning Completion - Router - POD' OR Name ='SAP Hardware Provisioning Completion - Streama - POD' OR Name ='SAP Hardware Provisioning Event - Router - POH' OR Name ='SAP Hardware Provisioning Event - Streama - POH' OR Name ='Fiber - Wait LeadId') GROUP BY Name