Поиск медленных ip клиетнов

slow_ip.sql

SELECT 
    floor(avg(resp_time), 2) AS avg_time, 
    ip
FROM access_log 
WHERE event_date = '2016-11-01'
GROUP BY ip
ORDER BY avg_time DESC
LIMIT 10