0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

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

fork query

edited feb 19 20 anonymous

created feb 18 20 jon.doe33206