Query: compute_network_subnet_status

select
  case when s.id is null then 'empty' else 'non-empty' end as status,
  count(distinct n.id)
from
   gcp_compute_network n
  left join gcp_compute_subnetwork s on s.network_name = n.name
group by
  status;