Non-deleted questions with most deleted answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

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

Options:
Switch sites:
loading Hold tight while we fetch your results