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;