Find number of Unanswered Questions on SO (questions with no answers at all)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Counts the number of unanswered questions on SO, that are not community-wiki, not closed and have no accepted answer.

Stack Overflow

Q&A for professional and enthusiast programmers

-- Enter Query Title
-- Enter Query Description

create table #unanswered (Id int primary key)

insert #unanswered 
select q.Id  from Posts q
where (select count(*) from Posts a where a.ParentId = q.Id) = 0
and CommunityOwnedDate is null and ClosedDate is null and q.ParentId is null 
and AcceptedAnswerId is null

Enter Parameters

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