SELECT --TOP 20 cast(c.creationdate as date) creation_date,

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT --TOP 20 
cast(c.creationdate as date) creation_date,
    COUNT(*) AS comment_count    
FROM Comments as c
    INNER JOIN Posts ON c.PostId = Posts.Id 
WHERE 
    Posts.Id in
    (31142674, 31126932, 31127023, 31129412, 31146538, 35790830)
    GROUP BY cast(c.creationdate as date)
--ORDER BY UpVotes DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results