List of Average Question Scores Per Tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Lists the average score of questions tagged with a given tag, for all tags (up to the SEDE maximum 50,000 output rows). Specify the score sort direction by setting sort order field to be ASC or DESC respectively.

Emacs

Q&A for those using, extending or developing Emacs

SELECT
  t.TagName,
  SUM(pwd.Score) * 1.0 / COUNT(pwd.Score) AS [Avg. Q Score],
  COUNT(pwd.Score) AS [Total Qs]
FROM PostTags pt
JOIN PostsWithDeleted pwd ON pwd.Id = pt.PostId
JOIN Tags t ON t.Id = pt.TagId
GROUP BY pt.TagId, t.TagName
HAVING COUNT(pwd.Score) >= ##cutoff:int?10##
ORDER BY SUM(pwd.Score) * 1.0 / COUNT(pwd.Score) ##sort?DESC##, COUNT(pwd.Score) DESC

-- sort: Sort Order ('DESC' for Highest Avg. First/ 'ASC' for Lowest):
-- cutoff: Sum Cutoff (Only show tags used at least this many times):

Enter Parameters

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