Query: ibm_compute_instance_by_floating_ip

with instances as (
  select
    case
      when jsonb_array_length(floating_ips) = 0 then 'private'
      else 'public'
    end as visibility
  from
    ibm_is_instance
)
select
  visibility,
  count(*)
from
  instances
group by
  visibility;