Question score vs. highest voted Answer score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT q.Score AS [Q-Score], a.Score as [A-Score]
FROM Posts q
INNER JOIN
 (SELECT DISTINCT a.ParentId, MAX(a.Score) AS [Score]
 FROM Posts a
 WHERE a.PostTypeId = 2 -- answers
 GROUP BY a.ParentId) a
ON q.Id = a.ParentId
WHERE q.PostTypeId = 1 -- questions
 AND q.ClosedDate is null -- not closed

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results