Query: app_service_web_app_by_network_traffic_protocol

select
  protocol,
  count(*)
from
  (
    select
      case
        when https_only :: boolean then 'HTTPS'
        else 'HTTP'
      end as protocol
    from
      azure_app_service_web_app
  ) as wa
group by
  protocol
order by
  protocol;