Query: app_service_web_app_by_http_logging

select
  http_logging,
  count(*)
from
  (
    select
      case
        when (
          configuration -> 'properties' ->> 'httpLoggingEnabled'
        ) :: boolean then 'Enabled'
        else 'Disabled'
      end as http_logging
    from
      azure_app_service_web_app
  ) as wa
group by
  http_logging
order by
  http_logging;