Query: ibm_kms_key_state

select
  case
    when state in ('2', '3') then 'disabled'
    else 'enabled'
  end as status,
  count(*)
from
  ibm_kms_key
where
  state <> '5'
group by
  status;