Hacker News Reader

Comment by Sukotto | Hacker News Reader

While it's cool they've had a million questions, I feel more interested in seeing stats on things like:

# non-closed questions (broken out by answered/non)

# questions with an accepted answer

# questions forced to community-wiki vs those that were not

Just go here and type in your SQL query:

Thank you very much for making this data available Joel. This is really interesting stuff.

I think these are right.

# non-closed questions (broken out by answered/non) - http://odata.stackexchange.com/stackoverflow/q/12626/

# questions forced to community-wiki vs those that were not - Don't know enough about their schema to answer this one. This could be the answer - http://odata.stackexchange.com/stackoverflow/q/12635/

>> # non-closed questions (broken out by answered/non)

Are the labels flipped? When AcceptedAnswerId is NULL, wouldn't that indicate a non-answered question?

Yes. I played with the order, but forgot to adjust the WHERE clauses.

This could be done using their data dumps (however I don't have access to SQL Server so I couldn't tell you this).

The data dumps are in an xml format, you don't need SQL Server to work with the data.