How to create archive list?

It might vary between databases, but in MySQL you could do something
like:

:select => "DATE_FORMAT('%m/%Y') as month_year,COUNT(posts.id) as
count"
:group => "month_year"
:order => "month_year"

That's just off the top of my head, but the idea is to use a GROUP BY
clause on month.