Query: 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
    aws_vpc as vpc
    left join aws_vpc_subnet as s on vpc.vpc_id = s.vpc_id
  where
    s.subnet_id is null;