Query: droplet_by_firewall_status

with database as (
  select
    case
      when jsonb_array_length(firewall_rules) = 0 then 'disabled'
      else 'enabled'
    end as firewall_status
  from
    digitalocean_database
)
select
  firewall_status,
  count(*) as "Clusters"
from
  database
group by
  firewall_status;