Query: sql_server_by_encryption_type

with encryption_type as (
  select
    id,
    ep -> 'serverKeyType' as serverKeyType
  from
    azure_sql_server as s,
    jsonb_array_elements(encryption_protector) as ep
)
select
  serverKeyType as "Server Key Type",
  count(serverKeyType) as "Servers"
from
  encryption_type
group by
  serverKeyType
order by
  serverKeyType;