2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional mathematicians

SELECT TOP ##num?250##
  UserId, UserDisplayName,
  CAST(CreationDate as Date),
  COUNT(DISTINCT RevisionGUID) AS editcount
  FROM PostHistory WHERE ((PostHistoryTypeId in (4,5,6)))
GROUP BY UserId, UserDisplayName, CAST(CreationDate as Date)
ORDER BY editcount DESC

fork query

created aug 19 18 Martin20528