0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT Tags.TagName,COUNT(*) AS 'Number of Questions',AVG(Posts.Score+0.0) AS 'average score'
FROM Posts,PostTags,Tags
WHERE Posts.Id=PostTags.PostId
  AND PostTags.TagId=Tags.Id
GROUP BY Tags.TagName
ORDER BY COUNT(*) DESC

fork query

edited mar 11 20

created mar 11 20 dan1st