List all questions, along with score, descriptive status, and close votes.
- For closed questions, the close votes count includes all votes, except for mod hammers.
- For open questions, the close votes count includes pending and aged away votes only.
Q&A about the site for operations research and analytics professionals, educators, and students
SELECT TOP 500
p.Id AS [Post Link],
p.Score AS [Question Score],
p.AnswerCount AS [# of Answers],
1-ISNULL(p.AcceptedAnswerId,0) AS [Accepted Answer?]
FROM PostsWithDeleted AS p
1 = 1
ORDER BY p.CreationDate;