Developer Story, minimal tag scores for 1-5-10-20 Pct for all tags of the site

1

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

WITH Raw AS (
  SELECT
    Posts.OwnerUserId AS UserId,
    PostTags.TagId,
    SUM(Posts.Score) AS Score
  FROM Posts, PostTags
  WHERE
    Posts.ParentId = PostTags.PostId
  GROUP BY Posts.OwnerUserId, PostTags.TagId
  HAVING Posts.OwnerUserId > 0 AND COUNT(*) > 1
)
SELECT TagId, Score, COUNT(*) AS UserCount
FROM Raw
GROUP BY TagId, Score

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results