Query: elasticache_cluster_node_by_engine

select
  engine as "Type",
  count(*) as "clusters"
from
  aws_elasticache_cluster
group by
  engine
order by
  engine;