Comments per users

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

SELECT 
    TOP 100
    Users.Id as [User Link],
    Users.CreationDate,
    Count(Comments.Id) AS Interactions
FROM
    Comments
  INNER JOIN
    Users ON Users.Id = UserId
WHERE
  Users.CreationDate > '2019-01-01 00:00:00'
GROUP BY
    Users.Id, UserDisplayName,Users.CreationDate
HAVING
    Count(Comments.Id) > 10
ORDER BY
    Interactions DESC

Enter Parameters

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