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


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

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