Query: lambda_function_invocation_rate

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