Q&A for ebook publishers and readers
select Convert (Date, CreationDate) as [Day], count (*) as Count from Posts where CreationDate >= '1 Jan 2015' group by Convert (Date, CreationDate)