s.ไม่จำเป็นที่จะต้องใช้ทุกตาราง
s.It is not neccessary to use all the tables.
 Posts:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT q.Title, q.Score AS QuestionScore, q.ViewCount, q.Tags, q.Id AS "post_link", ans.Score AS AnswerScore, ans.Id AS AnswerId FROM Posts AS ans JOIN Posts AS q ON ans.ParentId = q.Id WHERE q.ViewCount > 5000 AND ans.Score > 20 AND ans.OwnerUserId = 7586 ORDER BY q.ViewCount DESC