Number of questions that a given user has answered and edited as per the specifications of the Explainer, Refiner, and Illuminator badges.
Q&A for people looking to bypass life's everyday problems with simple tricks
select a.OwnerUserId as [User Link], count(PostId) as [Answer Edits] from Posts q join PostHistory e on PostId = q.Id join Posts a on a.ParentId = q.Id and IsNull(q.OwnerUserId, -1) <> a.OwnerUserId and UserId = a.OwnerUserId and abs(datediff(hour, a.CreationDate, e.CreationDate)) < 12 where PostHistoryTypeId in (4, 5, 6) -- Edit title, body, or tags and q.PostTypeId = 1 and a.PostTypeId = 2 and q.ClosedDate is null and a.Score >= 1 group by a.OwnerUserId having count(PostId) >= 500 order by count(PostId) desc