Query: oci_vcn_no_subnet

select
  case when s.id is null then 'empty' else 'non-empty' end as status,
  count(distinct v.id)
from
  oci_core_vcn v
  left join oci_core_subnet s on s.vcn_id = v.id
where
  v.lifecycle_state <> 'TERMINATED'
group by
  status;