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;