1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero

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

fork query

edited sep 15 19

created sep 15 19 lehalle