I am trying to look at the trends in answers over time per month and I noticed the discrepancy in the following query:
The Answers column is the COUNT(*) of all Posts where PostTypeId = 2 i.e Answers.
The TotalAnswers column is the SUM(AnswerCount) from the AnswerCount field of the Posts table
I'd like to know, why is there such a large difference between these two columns? It is such a large number that I expect there is something going on here.
This query returns no results:
SELECT * FROM Posts
WHERE PostTypeId = 2
AND ParentId IS NULL