Query: Top 10 Keys

select
  bucket || '/' || key as "URI",
  count(*) as "Request Count"
from
  aws_s3_server_access_log
where
  key is not null
group by
  "URI"
order by
  count(*) desc,
  "URI"
limit 10;