SELECT Posts.Id, COUNT(Comments.Id) FROM Posts JOIN Comme...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematica Meta

Q&A about the site for users of Wolfram Mathematica

SELECT Posts.Id, COUNT(Comments.Id) FROM Posts
JOIN Comments ON Comments.PostId = Posts.Id
WHERE YEAR(Posts.CreationDate) = '2023'
GROUP BY Posts.Id
HAVING COUNT(Comments.Id) >= 4

Enter Parameters

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