BD4E-Playground-Final

1

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

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