1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

WITH Raw AS (
  SELECT
    Posts.OwnerUserId AS UserId,
    PostTags.TagId,
    SUM(Score) AS Score
  FROM Posts, PostTags
  WHERE
    Posts.ParentId = PostTags.PostId
  GROUP BY Posts.OwnerUserId, PostTags.TagId
),
Raw2 AS (
  SELECT
    UserId,
    MAX(Score) AS MaxScore
  FROM Raw
  GROUP BY UserId
)
SELECT
  MIN(Tags.TagName) AS TagName,
  COUNT(*) AS Count
FROM Raw, Raw2, Tags
WHERE
  Raw.UserId = Raw2.UserId
  AND
  Raw.Score = Raw2.MaxScore
  AND
  Raw.TagId = Tags.Id
GROUP BY Raw.TagId
ORDER BY Count DESC, Raw.TagId

fork query

edited may 12

created may 12 peterh - PLEASE DELETE THIS ACCOUNT