Query: database_autonomous_db_by_cpu_utilization

with top_n as (
  select
    id,
    avg(average)
  from
    oci_database_autonomous_db_metric_cpu_utilization_daily
  where
    timestamp  >= CURRENT_DATE - INTERVAL '7 day'
  group by
    id
  order by
    avg desc
  limit 10
 )
select
  timestamp,
  id,
  average
from
  oci_database_autonomous_db_metric_cpu_utilization_hourly
where
  timestamp  >= CURRENT_DATE - INTERVAL '7 day'
  and id in (select id from top_n);