คำตอบทั้งหมดของฉันจัดเรียงตามการโหวต ไม่จำเป็นต้องใช้ตารางทั้งหมด
All My Answers Sorted by Votes.It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT COUNT(*) AS UpVotes, p2.Title FROM Posts AS p INNER JOIN Votes AS v ON v.PostId = p.Id INNER JOIN Posts AS p2 ON p2.Id = p.ParentId AND p2.PostTypeId = 1 WHERE p.OwnerUserId = @UserId AND p.PostTypeId = 2 AND v.VoteTypeId = 2 GROUP BY p2.Title ORDER BY UpVotes DESC