0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

WITH TagAnswerers AS (
  SELECT TagId
  FROM Posts
  INNER JOIN PostTags ON ParentId=PostId
  GROUP BY TagId, OwnerUserId
  HAVING 5 <= SUM(Score)
),
TagAnswererCounts AS (
  SELECT TagId, COUNT(*) AS Count
  FROM TagAnswerers
  GROUP BY TagId
  HAVING 5 <= COUNT(*)
)
SELECT TagName, TagAnswererCounts.Count
FROM TagAnswererCounts
INNER JOIN Tags ON TagId=Id
ORDER BY Count DESC

fork query

created may 3 21 sayuri