gistfile1.sql

SELECT app_id, AVG(logs.hits) AS hits_avg, SUM(logs.hits) AS hits, 
CONCAT(YEAR(logs.created_at), '-', LPAD(MONTH(logs.created_at), 2, '0'), '-', LPAD(DAY(logs.created_at), 2, '0'), ' ', LPAD(HOUR(logs.created_at), 2, '0'),':',LPAD(FLOOR(MINUTE(logs.created_at)/5)*5, 2, '0'), ':00') AS date_interval
FROM `logs`
WHERE logs.created_at > "2010-07-22 00:00:00"
GROUP BY app_id, date_interval
ORDER BY app_id;