Query: vpc_no_vswitch_count

select
  count(*) as value,
  'VPCs Without vSwitches' as label,
  case
    when count(*) = 0 then 'ok'
    else 'alert'
  end as type
from
  alicloud_vpc as vpc
  left join alicloud_vpc_vswitch as s on vpc.vpc_id = s.vpc_id
where
  s.vswitch_id is null;