Query: oci_vcn_subnet_by_region

select
  region as "Region",
  count(*) as "Subnets"
from
  oci_core_subnet
where
  lifecycle_state <> 'TERMINATED'
group by
  region
order by
  region;