Query: ec2_application_load_balancers_for_acm_certificate

select
  arn as alb_arn
from
  aws_ec2_application_load_balancer
where
  arn in (
    select
      jsonb_array_elements_text(in_use_by)
    from
      aws_acm_certificate
    where
      certificate_arn = $1
  );