Query: database_autonomous_db_by_operations_insights_status

select
  insight_status,
  count(*)
from (
  select operations_insights_status,
    case when operations_insights_status = 'NOT_ENABLED' then
      'disabled'
    else
      'enabled'
    end insight_status
  from
    oci_database_autonomous_database) as t
group by
  insight_status
order by
  insight_status desc;