Q&A for ebook publishers and readers
select TOP 10 Convert(Date, CreationDate), Count(*) from Posts group by Convert(Date, CreationDate) order by Convert(Date, CreationDate) desc