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