Posts per day per users (group by 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.DisplayName,
    Count(Comments.Id) AS Interactions,
    Comments.CreationDate as InteractionDate
FROM
    Comments
  INNER JOIN
    Users ON Users.Id = UserId
WHERE
  Users.CreationDate > '2019-01-01 00:00:00' -- recent users only
GROUP BY
    DisplayName,Comments.CreationDate
    
ORDER BY
    Interactions DESC,
    DisplayName DESC

Enter Parameters

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