2

Please login or register to vote for this query.

(click on this box to dismiss)

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)

fork query

edited may 30 13 conradfrix

created mar 30 13 anonymous