Query: sql_database_geo_redundant_backup_status

select
  geo_redundant_backup_status,
  count(*)
from (
  select
    case
      when
        retention_policy_property ->> 'monthlyRetention' <> 'PT0S'
        or retention_policy_property ->> 'weeklyRetention' <> 'PT0S'
        or retention_policy_property ->> 'yearlyRetention' <> 'PT0S' then 'enabled'
      else 'disabled'
    end geo_redundant_backup_status
  from
    azure_sql_database) as s
group by
  geo_redundant_backup_status
order by
  geo_redundant_backup_status;