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;