Query: ec2_application_load_balancer_az_zone

select
  'Availibility Zones' as label,
  count(az ->> 'ZoneName') as value,
  case when count(az ->> 'ZoneName') > 1 then 'ok' else 'alert' end as type
from
  aws_ec2_application_load_balancer
  cross join jsonb_array_elements(availability_zones) as az
where
  arn = $1;