0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

SELECT Tags.TagName AS [Tag Link], AVG(A.Score * 100) AS avg100, COUNT(A.Score) AS answerCount
FROM Tags, PostTags, Posts AS Q, Posts AS A
WHERE Tags.Count >= 1000
  AND Tags.Id = PostTags.TagId
  AND PostTags.PostId = Q.Id
  AND A.ParentId = Q.Id
GROUP BY Tags.Id, Tags.TagName
ORDER BY avg100 DESC

fork query

edited feb 14 13

created feb 14 13 jon.doe10496