0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

-- Reference: https://meta.stackexchange.com/questions/2677/database-schema-documentation-for-the-public-data-dump-and-sede/2678#2678

SELECT 
  a.UserId AS [User Link]
  , COUNT(a.PostId) AS "Count"
  , a.UserId as "UserId"
FROM 
  PostHistory a
  INNER JOIN Posts b
  ON a.PostId = b.id
WHERE 
  a.PostHistoryTypeId = 5 -- Edit Body
  AND b.CreationDate < '2014-01-01'
  AND a.CreationDate >= '2017-01-01'
GROUP BY a.UserId
ORDER BY COUNT(a.PostId) DESC;

fork query

edited jun 18 17 David Carlisle

created jun 17 17 ShreevatsaR