Query: Top 10 Source IPs

select
  tp_source_ip as "Client IP",
  count(*) as "Request Count"
from
  aws_s3_server_access_log
where
  tp_source_ip != ''
group by
  tp_source_ip
order by
  count(*) desc,
  tp_source_ip
limit 10;