Query: List reserved cache nodes order by duration

Description

Determine the areas in which cache nodes are reserved for the longest duration. This can help prioritize which nodes to investigate for potential cost savings or performance improvements.

Query

Tables used in this query:

• aws_elasticache_reserved_cache_node

SQL