Query: List instances stopped for more than 30 days

Description

Determine the areas in which AWS EC2 instances have been stopped for over 30 days. This can be useful for identifying and managing instances that may be unnecessarily consuming resources or costing money.

Query

Tables used in this query:

• aws_ec2_instance

SQL