Total score for answers in a given tag (only non-CW anwers)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT TOP ##num?100##
a.OwnerUserId AS [User Link], a.OwnerDisplayName, SUM(a.Score) AS [Total Score], COUNT(a.Score) AS [Count], AVG(CAST(a.Score AS decimal))  AS [Average Score]
FROM Posts a JOIN Posts q ON a.ParentId=q.Id
WHERE a.PostTypeId=2 AND q.Tags LIKE '%<##tagName?elementary-set-theory##>%'
  AND a.CommunityOwnedDate IS NULL
GROUP BY a.OwnerUserId, a.OwnerDisplayName
ORDER BY SUM(a.Score) DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results