โพสต์และยอมรับคำตอบตามภาษา ไม่จำเป็นต้องใช้ตารางทั้งหมด
Post and Accepted Answer by language.It is not neccessary to use all the tables.
 PostFeedback:  Id [ number]  PostId [ number]  IsAnonymous [ boolean]  VoteTypeId [ number]  CreationDate [ time] 
SELECT p.Id, p.AcceptedAnswerId, p.CreationDate, p.OwnerUserId, p.Tags, p.Title, p.Body AS Question, a.Body AS Answer FROM Posts AS p INNER JOIN Posts AS a ON p.AcceptedAnswerId = a.Id WHERE p.Tags LIKE '%pega%' AND p.PostTypeId = 1 AND a.PostTypeId = 2 AND NOT p.AcceptedAnswerId IS NULL AND p.DeletionDate IS NULL