Query: app_service_web_app_by_status

select
  status,
  count(*)
from
  (
    select
      case
        when enabled :: boolean then 'online'
        else 'offline'
      end as status
    from
      azure_app_service_web_app
  ) as wa
group by
  status
order by
  status;