Query: ibm_kms_key_by_algorithm

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