Query: kms_key_by_state

select
  key_state,
  count(key_state)
from
  aws_kms_key
group by
  key_state;