Total score of answers for the question

0

Please login or register to vote for this query.

(click on this box to dismiss)

MathOverflow

Q&A for professional mathematicians

SELECT 
  q.Id AS [Post Link],
  SUM(a.Score) [Total Answers Score]
FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id 
WHERE q.PostTypeId=1
---only questions: p.PostTypeId=1
AND (q.CreationDate >= '##Date1?2020-01-01##') AND (q.CreationDate <= '##Date2?2021-01-01##')
---restriction on date
GROUP BY q.Id
ORDER BY q.Id

Enter Parameters

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