Query: droplet_by_public_access

with droplets as (
  select
    case
      when image ->> 'public' = 'true' then 'public'
      else 'private'
    end as public_access
  from
    digitalocean_droplet
)
select
  public_access,
  count(*) as "Droplets"
from
  droplets
group by
  public_access;