Query: ibm_kms_key_by_state

select
  case
    when state = '0' then 'Pre-activation'
    when state = '1' then 'Enabled'
    when state = '2' then 'Disabled'
    when state = '3' then 'Deactivated'
    when state = '5' then 'Deleted'
    else state
    end as state_code,
  count(*)
from
  ibm_kms_key
group by
  state_code;