Query: List clusters whose availability zone count is less than 2

Description

Determine the areas in which your AWS ElastiCache clusters are potentially vulnerable due to having less than two availability zones. This could be useful for improving disaster recovery strategies and ensuring high availability.

Query

Tables used in this query:

• aws_elasticache_cluster

SQL