Interactions 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(Posts.Id) AS Interactions
FROM
    Posts
  INNER JOIN
    Users ON Users.Id = OwnerUserId
--WHERE
--    PostTypeId = 2 and CommunityOwnedDate is null and ClosedDate is null
-- PostTypeId = 2: answer
-- comments are not included
WHERE
  Users.CreationDate > '2019-01-01 00:00:00'
GROUP BY
    Users.Id, DisplayName,Users.CreationDate
HAVING
    Count(Posts.Id) > 10
ORDER BY
    Interactions DESC

Enter Parameters

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