Query: ibm_is_vpc_no_subnet_count

select
   count(*) as value,
  'VPCs Without Subnets' as label,
   case when count(*) = 0 then 'ok' else 'alert' end as type
from
  ibm_is_vpc as v
  left join ibm_is_subnet as s on v.id = s.vpc ->> 'id'
where
  s.id is null;