Query: compute_virtual_machine_by_public_ip

with vm_visibility as (
  select
    case
      when public_ips is null then 'private'
      else 'public'
    end as visibility
  from
    azure_compute_virtual_machine
)
select
  visibility,
  count(*)
from
  vm_visibility
group by
  visibility