Query: vpc_subnets_for_ec2_classic_load_balancer

select
  vs.subnet_id as subnet_id
from
  aws_vpc_subnet vs,
  aws_ec2_classic_load_balancer as alb,
  jsonb_array_elements_text(alb.subnets) as s
where
  alb.arn = $1
  and vs.subnet_id = s;