0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professional and enthusiast programmers

SELECT

COUNT(*),
CAST(CreationDate AS Date) AS Day

FROM Comments 

WHERE CreationDate > DATEADD(dd, -90, GETDATE())

GROUP BY CAST(CreationDate AS Date)

ORDER BY CAST(CreationDate AS Date) DESC

fork query

created jul 31 19 anonymous