Query: sql_database_tde_status

select
  tde_status,
  count(*)
from (
  select
    case when transparent_data_encryption ->> 'status' <> 'Enabled' then 'disabled'
    else 'enabled'
    end tde_status
  from
    azure_sql_database) as s
group by
  tde_status
order by
  tde_status;