Query: ibm_kms_key_by_account

select
  a.name as "Account",
  count(k.*) as "Keys"
from
  ibm_kms_key as k,
  ibm_account as a
where
  k.account_id = a.customer_id
  and k.state <> '5'
group by
  a.name
order by
  a.name;