Query: ibm_subnet_count_for_vpc

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