Tags ordered by average answer score (non CW)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

SELECT TOP(##num?100##)
  RANK() OVER(ORDER BY AVG(CAST(a.SCORE AS decimal)) DESC) AS Rank,
  t.Tagname,
  AVG(CAST(a.Score AS decimal)) AS [Average Score],
  COUNT(a.Id) AS Count,
  SUM(a.Score) AS [Total Score]
FROM Posts q INNER JOIN Posts a ON q.Id=a.ParentId
  INNER JOIN PostTags pt ON q.Id=pt.PostId
  INNER JOIN Tags t ON t.id = pt.TagId
WHERE (a.CommunityOwnedDate IS NULL)
---only non-CW
GROUP BY t.Tagname
HAVING (COUNT(a.Id)>=##min?10##)
ORDER BY AVG(CAST(a.SCORE AS decimal)) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results