Q&A for writers/artists using science, geography and culture to construct imaginary worlds and settings
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)