Query: Top 10 URIs (Successful Requests)

select
  bucket || split_part(request_uri, ' ', 2) as "URI",
  count(*) as "Request Count",
  string_agg(distinct http_status::text, ', ' order by http_status::text) as "Status Codes"
from
  aws_s3_server_access_log
where
  http_status between 200 and 299
group by
  "URI"
order by
  count(*) desc,
  "URI"
limit 10;