Unanswered questions that have a zero-score answer from the questioner

Questions that can be marked as answered by upvoting a self-answered question.

Q&A for users and developers of hardware and software for Raspberry Pi

-- Unanswered questions that have a zero-score answer from the questioner
-- Questions that can be marked as answered by upvoting a self-answered question.
SELECT q.Id AS [Post Link]
FROM Posts q
WHERE q.PostTypeId = 1
AND q.ClosedDate IS NULL
AND q.AcceptedAnswerId IS NULL
AND q.AnswerCount > 0
AND EXISTS (SELECT a.Id
FROM Posts a
WHERE a.Score = 0
AND a.ParentId = q.Id
AND a.OwnerUserId = q.OwnerUserId)
AND NOT EXISTS (SELECT a.Id
FROM Posts a
WHERE a.Score > 0
AND a.ParentId = q.Id)
ORDER BY q.Id ASC