Q&A for professional and enthusiast programmers
Select q.Id as [Post Link], q.Score, q.OwnerUserId as [User Link], q.CreationDate as [Created], q.ClosedDate as [Closed] from Posts q inner join PostHistory ph on q.Id = ph.PostId where PostTypeId = 1 and ClosedDate is not null and ph.PostHistoryTypeId = 10 and ph.Comment = 104 order by q.Score DESC