Query: storage_account_blob_soft_delete_status

select
  blob_soft_delete,
  count(*)
from
  (
    select
      case
        when blob_soft_delete_enabled then 'enabled'
        else 'disabled'
      end blob_soft_delete
    from
      azure_storage_account
  ) as cd
group by
  blob_soft_delete
order by
  blob_soft_delete;