Total tag score vs no. of answers in tag for a given user

2

Please login or register to vote for this query.

(click on this box to dismiss)

Returns a distribution, for a given user and over all the tags that user has answered, of the users' total score on that tag (horizontal axis) versus the total number of answers they've written (vertical axis).

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
--Tags.TagName,
SUM(answers.Score) AS TagScore,
COUNT(answers.Id) AS TotalAnswers
FROM Tags
INNER JOIN Posts questions ON questions.Tags LIKE '%<'+Tags.TagName+'>%'
INNER JOIN Posts answers ON answers.ParentId = Questions.Id
WHERE answers.OwnerUserId = ##userId##
  AND questions.CommunityOwnedDate IS NULL
GROUP BY Tags.TagName
ORDER BY TagScore

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results