0

Please login or register to vote for this query.

(click on this box to dismiss)

Finds number of questions that have no accepted answer and no answers with a score >= 0 after three months

Q&A for anime and manga fans

-- Q's with no A's >= 0 after three months
-- Finds number of questions that have no accepted answer and no answers with a score >= 0 after three months

select count(*) from posts as q
where PostTypeId=1
AND Score < 1
AND CreationDate < DATEADD(MONTH, -3, GETDATE())
AND ClosedDate is null
and AcceptedAnswerId is null
AND NOT EXISTS (
    select * from posts as a where PostTypeId=2 and ParentId=q.id and Score>=0
)

fork query

created oct 22 10 Brad Mace