50 คำตอบที่ได้รับคะแนนสูงสุดของฉันสำหรับคำถามที่ไม่มีคำตอบที่ยอมรับ ไม่จำเป็นต้องใช้ตารางทั้งหมด
My 50 Highest Rated Answers On Questions With No Accepted Answer.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 p.Id AS "post_link", COALESCE(p.LastEditDate, p.CreationDate) AS MostRecentChange, (SELECT COUNT(v.Id) FROM Votes AS v INNER JOIN VoteTypes AS vt ON v.VoteTypeId = vt.Id WHERE vt.Name = 'UpMod' AND v.PostId = p.Id) AS UpVotes, (SELECT COUNT(v.Id) FROM Votes AS v INNER JOIN VoteTypes AS vt ON v.VoteTypeId = vt.Id WHERE vt.Name = 'DownMod' AND v.PostId = p.Id) AS DownVotes, p.Score FROM Posts AS p INNER JOIN PostTypes AS pt ON pt.Id = p.PostTypeId INNER JOIN Posts AS p2 ON p.ParentId = p2.Id WHERE pt.Name = 'Answer' AND p.OwnerUserId = @UserId AND p2.AcceptedAnswerId IS NULL ORDER BY p.Score DESC, p.LastEditDate DESC LIMIT 50