Query: database_autonomous_db_data_guard_status

  with dataguard_stat as (
    select
      case
        when is_data_guard_enabled then 'enabled'
        else 'disabled'
      end as dataguard_stat
    from
      oci_database_autonomous_database
    )
select
  dataguard_stat,
  count(*)
from
  dataguard_stat
  group by dataguard_stat