Query: elasticache_cluster_node_by_automatic_backup_status

select
  automatic_backup_status,
  count(*)
from
  (
    select
      snapshot_retention_limit,
      case
        when snapshot_retention_limit is not null then 'enabled'
        else 'disabled'
      end automatic_backup_status
    from
      aws_elasticache_cluster
  ) as a
group by
  automatic_backup_status
order by
  automatic_backup_status desc;