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;