Downloads over past 7 days

SELECT s3key, round(sum(bytes_sent)/max(bytes)) as count, min(dtime) as first,max(dtime) as last FROM downloads LEFT JOIN downloadable ON downloads.did = downloadable.id WHERE dtime > DATE_ADD(NOW(), INTERVAL -7 DAY) GROUP BY s3key HAVING count>=1 ORDER BY count DESC