Query: nosql_table_top_10_read_throttle_count_avg

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