Query: api_gatewayv2_api_endpoint_status

with apis_with_api_endpoint_status as (
  select
    name,
    case
      when disable_execute_api_endpoint then 'Disabled'
      else 'Enabled'
    end as api_endpoint
  from
    aws_api_gatewayv2_api
)
select
  api_endpoint,
  count(*)
from
  apis_with_api_endpoint_status
group by
  api_endpoint;