To which tags do I answer?

1

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

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