Top score in answer between two dates in a specific tag

1

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

SELECT TOP(##num?500##)
  RANK() OVER(ORDER BY SUM(a.Score) DESC) AS [Rank],
  a.OwnerUserId AS [User Link],
  SUM(a.Score) AS [Total Score],
  COUNT(a.Id) AS [Count]
FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id
  INNER JOIN PostTags pt ON q.Id=pt.PostId
  INNER JOIN Tags t ON t.id = pt.TagId
  WHERE (t.TagName=##tag:string?support##) 
  AND (a.CreationDate >= '##Date1?2020-01-01##') AND (a.CreationDate <= '##Date2?2021-01-01##')
  ---AND (PostTypeId=2) ---answers
GROUP BY a.OwnerUserId
ORDER BY SUM(a.Score) DESC

Enter Parameters

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