流量费用

在实时查询页签下，输入以下查询和分析语句，查询examplebucket中高频访问文件及其对应的热门访问IP，并按访问次数排序，返回前5条记录。

* and __topic__: oss_access_log and bucket: examplebucket

| SELECT

client_ip AS ip_address,

request_uri AS file_path,

COUNT(*) AS access_count,

SUM(content_length_out) AS total_bytes_sent

FROM

log

WHERE

http_status = 200

GROUP BY

request_uri, client_ip

ORDER BY

access_count DESC

LIMIT 5;查询和分析结果如下：