Q&A for speakers of other languages learning English
select Convert (Date, CreationDate) as [Day], count (*) as Count from Posts where CreationDate >= '1 Jan 2015' group by Convert (Date, CreationDate)