Query: ecs_instance_by_public_ip

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