Q&A for people studying math at any level and professionals in related fields
select *, count(*) from ( select CAST( cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-' + cast(DATEPART(DD, CreationDate) as varchar) as datetime) [Day] from Posts p join PostTags pt on pt.PostId = p.Id join Tags t on t.Id = pt.TagId where p.CreationDate > '2013-01-01' AND p.CreationDate < '2014-01-01' --AND P.PostTypeID = 1 --AND P.ParentId IS NULL AND TagId in ( select tt.Id from Tags tt where LEFT(UPPER(tt.TagName),7)='ASP.NET' ) ) as X group by [Day] order by [Day] asc