Longest 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 desc limit 20

Day AverageLength PostCount
21/12/2002 2707.0000 1
24/12/2002 1896.0000 1
04/01/2003 1461.0000 1
19/12/2002 1309.0000 2
01/05/2003 1220.2222 9
27/11/2002 1097.0000 1
19/10/2003 954.0909 11
02/07/2004 876.0000 1
17/12/2002 868.0000 1
28/12/2002 793.0000 2
24/09/2006 782.6667 3
23/02/2009 768.0000 1
23/09/2006 709.0000 1
10/06/2002 693.0000 1
25/11/2002 690.0000 3
16/12/2002 686.0000 2
19/02/2004 655.6154 13
02/05/2003 630.2778 18
30/11/2006 629.1429 7
06/08/2004 593.0000 1