To which tags do I answer?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

SELECT TOP 100 
  MAX(t.TagName),
  Count(1) as nbe_questions,
  AVG(Questions.Score) as Q_score,
  AVG(Answers.Score) as A_score
FROM
  Posts as Questions,
  Posts as Answers,
  PostTags as pt,
  Tags as t
WHERE
  pt.TagId = t.Id AND
  pt.PostId = Questions.Id AND
  pt.PostId = Questions.Id AND
  Questions.PostTypeId  = 1 AND
  Answers.PostTypeId  = 2 AND
  Answers.ParentId = Questions.Id AND
  Answers.OwnerUserId = ##UserId## 
GROUP BY pt.TagId
ORDER BY nbe_questions DESC

Enter Parameters

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