Q&A for professional and enthusiast programmers
SELECT questions.Id AS [Post Link], COUNT(*) AS 'AnswerCount' FROM Posts questions JOIN Posts answers ON answers.ParentId = questions.Id WHERE questions.OwnerUserId = ##UserId## AND questions.PostTypeId = 1 --questions AND questions.AcceptedAnswerId IS NULL GROUP BY questions.Id