ที่ยอมรับคำตอบแล้วอาจไม่สนับสนุนให้มีการเพิ่มคำตอบมากขึ้น ไม่จำเป็นต้องใช้ตารางทั้งหมด
s that have accepted answers may discourage more answers being added.It is not neccessary to use all the tables.
 Badges:  Id [ number]  UserId [ number]  Name [ text]  Date [ time]  Class [ number]  TagBased [ boolean] 
WITH Accepted AS (SELECT xID = 1, AVG(CAST(p.AnswerCount AS FLOAT)) AS AcceptedCount FROM Posts AS p INNER JOIN Posts AS a ON p.Id = a.ParentId INNER JOIN Votes AS v ON a.Id = v.PostId WHERE p.PostTypeId = 1 AND p.AnswerCount > 0 AND v.VoteTypeId = 1 AND NOT p.AcceptedAnswerId IS NULL), NoAccepted AS (SELECT xID = 1, AVG(CAST(p.AnswerCount AS FLOAT)) AS NoAcceptedCount FROM Posts AS p WHERE p.PostTypeId = 1 AND p.AnswerCount > 0 AND p.AcceptedAnswerId IS NULL) SELECT AcceptedCount, NoAcceptedCount FROM Accepted AS a INNER JOIN NoAccepted AS na ON a.xID = na.xID