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;