BD4E-Playground-Final

1

Please login or register to vote for this query.

(click on this box to dismiss)

Moderators

Q&A for community managers, administrators, and moderators

SELECT TagName, AVG(Cast(Score as Float)) as AvgScore
FROM (
  SELECT QualifyingTags.Id as TagId, TagName, PostId, Score
  FROM (
    SELECT *
    FROM Tags
    WHERE Count>=5
    ) QualifyingTags
  JOIN PostTags on PostTags.TagId=QualifyingTags.Id
  JOIN Posts on Posts.Id=PostId
  ) TagsQuestionsScores
GROUP BY TagName
ORDER BY AvgScore DESC

Enter Parameters

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