Query: ibm_kms_key_by_region

select
  region,
  count(k.*) as "Keys"
from
  ibm_kms_key as k
where
  k.state <> '5'
group by
  region;