Query: List EC2 instances using AMIs owned by a specific AWS account

Description

Explore which EC2 instances are using AMIs owned by a particular AWS account. This is useful to maintain account security and manage resources efficiently.

Query

Tables used in this query:

• aws_ec2_ami_shared

SQL