Query: key_vault_by_soft_delete_status

select
  status,
  count(*)
from (
  select soft_delete_enabled,
    case when soft_delete_enabled then 'enabled'
    else 'disabled'
    end status
  from
    azure_key_vault) as kv
group by
  status
order by
  status;