Non-deleted questions with most deleted answers


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top ##number:int?100## q.Id as [Post Link], count(1) as DeletedAnswers, q.AnswerCount as ExtantAnswers 
from Posts q
inner join PostsWithDeleted a on a.ParentId = q.Id
where a.DeletionDate is not null
group by q.Id, q.AnswerCount
order by DeletedAnswers desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results