จำนวนการดูโพสต์ที่มีคะแนนสูง ไม่จำเป็นต้องใช้ตารางทั้งหมด
viewcounts for posts with a hihg score.It is not neccessary to use all the tables.
 TagSynonyms:  Id [ number]  SourceTagName [ text]  TargetTagName [ text]  CreationDate [ time]  OwnerUserId [ number]  AutoRenameCount [ number]  LastAutoRename [ time]  Score [ number]  ApprovedByUserId [ number]  ApprovalDate [ time] 
SELECT p.ViewCount, CASE p.PostTypeId WHEN 1 THEN 'Q' WHEN 2 THEN 'A' END AS QA, p.Id AS "post_link" FROM Posts AS p WHERE p.Score > 100 ORDER BY p.ViewCount DESC