Query: cosmosdb_account_by_encryption_type

select
  encryption as "Encryption",
  count(*) as "Accounts"
from
  (
    select
      case
        when key_vault_key_uri is null then 'Platform-Managed'
        else 'Customer-Managed'
      end encryption
    from
      azure_cosmosdb_account
  ) as s
group by
  "Encryption"
order by
  "Encryption";