Tags ordered by average question score (including CW)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Different

Q&A for power users of Apple hardware and software

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

Enter Parameters

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