Q&A for Graphic Design professionals, students, and enthusiasts
SELECT cast(Posts.CreationDate as date) AS Date, COUNT(Posts.Id) AS PostsCount FROM Posts WHERE Posts.PostTypeId=1 GROUP BY cast(Posts.CreationDate as date) ORDER BY cast(Posts.CreationDate as date)