Q&A for professional and enthusiast programmers
SELECT CONVERT(date, CreationDate) AS [Date Posted], ISNULL(COUNT(*), 0) AS [Questions Asked] FROM Posts WHERE PostTypeId = 1 AND CHARINDEX(##TagName:string##, Tags) > 0 GROUP BY CONVERT(date, CreationDate) ORDER BY CONVERT(date, CreationDate)