Counts the number of title and/or body revisions they've made
on other people's non-deleted posts.
Q&A for professional and enthusiast programmers
-- Who's closest to getting Strunk and White and Copy Editor
-- Counts the number of title and/or body revisions they've made
-- on other people's non-deleted posts.
SELECT ph.UserId as [User Link], COUNT(DISTINCT ph.RevisionGUID) as Edits
FROM PostHistory ph
ph.PostHistoryTypeId IN (4, 5) AND
ph.PostId NOT IN (SELECT p.Id FROM Posts p WHERE p.OwnerUserId = ph.UserId)
GROUP BY ph.UserId
ORDER BY Edits DESC