Shortest average posts by day

select date_format(max(time), '<a href="/%Y/%m/%d/">%d/%m/%Y</a>') as Day, avg(length(comment)) as AverageLength, count(*) as PostCount from columnc group by to_days(time) order by AverageLength limit 20