1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT TOP(##num?100##)
  RANK() OVER(ORDER BY AVG(CAST(a.SCORE AS decimal)) DESC) AS Rank,
  t.Tagname,
  AVG(CAST(a.Score AS decimal)) AS [Average Score],
  COUNT(a.Id) AS Count,
  SUM(a.Score) AS [Total Score]
FROM Posts q INNER JOIN Posts a ON q.Id=a.ParentId
  INNER JOIN PostTags pt ON q.Id=pt.PostId
  INNER JOIN Tags t ON t.id = pt.TagId
WHERE (a.CommunityOwnedDate IS NULL)
---only non-CW
GROUP BY t.Tagname
HAVING (COUNT(a.Id)>=##min?10##)
ORDER BY AVG(CAST(a.SCORE AS decimal)) DESC

fork query

created dec 9 Martin20528