0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT q.Id AS [QId], q.Score AS [QScore], a.Score AS [AcceptedScore], Year(a.CreationDate) AS [AcceptedYear]
FROM Posts q
INNER JOIN Posts a
ON q.AcceptedAnswerId = a.Id
WHERE q.ClosedDate is null and q.PostTypeId = 1 and q.Score > 2
and q.AcceptedAnswerId is not null and q.AnswerCount > 1 and Year(q.CreationDate) = ##Y?2011##
ORDER BY q.Id

fork query

edited feb 22

created feb 22 Trilarion