โพสต์ที่มีคำตอบ "ขอบคุณ" มากมาย เรียงตามจำนวนการดู ดูโพสต์ที่สั้นกว่า 200 โดยมีข้อความ `ขอบคุณ` อยู่ในนั้น เรียงลำดับตามจำนวนการดู ไม่จำเป็นต้องใช้ตารางทั้งหมด
Posts with many 'thank you' answers, ordered by views. Looking at posts shorter than 200 with the text `thank` somewhere in it, ordered by viewsIt is not neccessary to use all the tables.
 CloseAsOffTopicReasonTypes:  Id [ number]  IsUniversal [ boolean]  InputTitle [ text]  MarkdownInputGuidance [ text]  MarkdownPostOwnerGuidance [ text]  MarkdownPrivilegedUserGuidance [ text]  MarkdownConcensusDescription [ text]  CreationDate [ time]  CreationModeratorId [ number]  ApprovalDate [ time]  ApprovalModeratorId [ number]  DeactivationDate [ time]  DeactivationModeratorId [ number] 
SELECT a.ParentId AS "post_link", COUNT(a.Id), SUM(q.ViewCount) / COUNT(a.Id) FROM Posts AS a INNER JOIN Posts AS q ON a.ParentId = q.Id WHERE q.PostTypeId = 1 AND a.PostTypeId = 2 AND LENGTH(a.Body) <= 200 AND (a.Body LIKE '%thank%') GROUP BY a.ParentId HAVING COUNT(a.Id) > 1 ORDER BY COUNT(a.Id) DESC, SUM(q.ViewCount) DESC