เปอร์เซ็นต์ที่มีอย่างน้อยหนึ่งคำตอบ และเปอร์เซ็นต์ที่มีคำตอบ *ดี* อย่างน้อยหนึ่งคำตอบ (คะแนน > 0) คะแนนคำถามจะถูกละเว้น ไม่จำเป็นต้องใช้ตารางทั้งหมด
s, percentage that have at least one answer, and the percentage that have at least one *good* answer (Score > 0). Question scores are ignored.It is not neccessary to use all the tables.
 PendingFlags:  Id [ number]  FlagTypeId [ number]  PostId [ number]  CreationDate [ time]  CloseReasonTypeId [ number]  CloseAsOffTopicReasonTypeId [ number]  DuplicateOfQuestionId [ number]  BelongsOnBaseHostAddress [ text] 
WITH quarters AS (SELECT DATEPART(yyyy, Question.CreationDate) AS Year, DATEPART(mm, Question.CreationDate) AS Month, COUNT(*) AS Total, SUM(CASE WHEN Question.AnswerCount > 0 THEN 1 ELSE 0 END) AS Answered, SUM(CASE WHEN NOT Answer.Id IS NULL THEN 1 ELSE 0 END) AS GoodAnswer FROM Posts AS Question LEFT JOIN Posts AS Answer ON Answer.PostTypeId = 2 AND Answer.ParentId = Question.Id AND Answer.Score > 0 WHERE Question.PostTypeId = 1 AND Question.ClosedDate IS NULL GROUP BY DATEPART(yyyy, Question.CreationDate), DATEPART(mm, Question.CreationDate)) SELECT DATEADD(mm, Month - 1, DATEADD(yy, Year - 1900, 0)), Total AS Questions, Answered AS "answer", GoodAnswer AS "goodanswer" FROM quarters ORDER BY Year, Month