Query: kms_key_rotation_status

select
  lower(rotation_status),
  count(*) as "Keys"
from (
  select
    automatic_rotation as rotation_status
  from
    alicloud_kms_key) as t
group by
  rotation_status
order by
  rotation_status desc;