Query: compute_network_subnet_count

select
  'Subnets' as label,
  count(*) as value,
  case
    when count(*) > 0 then 'ok'
    else 'alert'
  end as type
from
  gcp_compute_subnetwork s,
  gcp_compute_network n
where
  s.network_name = n.name
  and s.project = n.project
  and n.id = $1;