SELECT CASE state 
  WHEN 0 THEN 'Running'
  WHEN 1 THEN 'Completed' 
  WHEN 2 THEN 'Running with Faults'  
  WHEN 3 THEN 'Completed with Faults'  
  WHEN 4 THEN 'Running with Recovery Required'  
  WHEN 5 THEN 'Completed with Recovery Required'  
  WHEN 6 THEN 'Running with Fault and Recovery Required'  
  WHEN 32 THEN 'Unknown'  
  WHEN 64 THEN 'Stale'  
  END AS STATE, COUNT(state) FROM SOAINFRA.COMPOSITE_INSTANCE WHERE source_name = '<servis adi>' GROUP BY state ORDER BY state;

select case state when 0 then 'Running' when 1 then 'Completed' when 2 then 'Running with Faults' when 3 then 'Completed with Faults' when 4 then 'Running with Recovery Required' when 5 then 'Completed with Recovery Required' when 6 then 'Running with Fault and Recovery Required' when 32 then 'Unknown' when 64 then 'Stale' END as STATE, count(state) from SOAINFRA.COMPOSITE_INSTANCE where source_name = '<servis adi>' group by state order by state;