Query: app_service_web_app_by_state

select
  state as "State",
  count(id) as "Web Apps"
from
  azure_app_service_web_app
group by
  state
order by
  state;