ด้วยคำตอบที่ยอมรับได้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
s with an accepted answer.It is not neccessary to use all the tables.
 PostHistoryTypes:  Id [ number]  Name [ text] 
SELECT Posts.Id AS "post_link", Posts.ViewCount AS "views", Posts.AnswerCount AS "#_answers" FROM Posts WHERE PostTypeId = 1 AND NOT Posts.AcceptedAnswerId IS NULL ORDER BY Posts.AnswerCount DESC