I'm trying to query the great Data Explorer tool to ask all kinds of questions about unanswered questions on Stack Overflow.
The problem is that there's a vast inconsistency between the results I get in my queries and the results that Stack Overflow publishes on the main site.
Specifically, Stack Overflow declares that there are
651,080 questions with no answers
However when I run this simple query which should give me the same result on Stack Overflow's DB -
select count(*) from posts where posttypeid = 1 and answercount = 0
I get this result -
Unless I've written the wrong query for what I would like to know, this number is far off what Stack Overflow's officially declare (for the better).
Can anyone please help me understand why I get this inconsistency?