Query: Find the number of available IP address in each subnet

Description

Determine the areas in which there are available IP addresses within each subnet. This is useful for understanding where there is capacity for new devices or services.

Query

Tables used in this query:

• aws_vpc_subnet

SQL