Query: compute_instance_by_public_ip

with instances as (
  select
    case
      when a.public_ip is null then 'private'
      else 'public'
    end as visibility
  from
    oci_core_instance as i,
    oci_core_vnic_attachment as a
  where
    i.id = a.instance_id and i.lifecycle_state <> 'TERMINATED'
)
select
  visibility,
  count(*)
from
  instances
group by
  visibility;