Query: oci_vcn_subnet_by_vcn

select
  v.display_name as "VCN",
  count(*) as "subnets"
from
  oci_core_subnet s
  left join oci_core_vcn v on s.vcn_id = v.id
where
  s.lifecycle_state <> 'TERMINATED'
group by
  v.display_name
order by
  v.display_name;