Q&A for speakers of other languages learning English
select TOP 10 Convert(Date, CreationDate), Count(*) from Posts group by Convert(Date, CreationDate) order by Convert(Date, CreationDate) desc