Query: compute_network_no_subnet_count

select
  count(*) as value,
  'Networks Without Subnets' as label,
  case
    when count(*) = 0 then 'ok'
    else 'alert'
  end as type
from
  gcp_compute_network as n
  left join gcp_compute_subnetwork as s on n.name = s.network_name
where
  s.id is null;