Average post count between 2 dates?

[Eikinskjaldi]

Originally Posted by Geraldm

Hi,

I need some help programming the following:

I need to get the top 10 forum members which have the highest average daliy post count between the 17th April 07 and the 18th of June 07.

If anyone can come up with some code to display this I am willing to pay $$ for your efforts

Thanks,
Gerald.

[sql]
select userid, count(*) as 'total' from post
where dateline between (unix_timestamp('2007-04-17'), unix_timestamp('2007-06-18'))
group by userid order by total desc limit 10;
[/sql]