โพสต์ที่แท็กด้วย TagName เรียงลำดับตาม upvotes DESC ไม่จำเป็นต้องใช้ตารางทั้งหมด
Posts tagged with TagName ordered by upvotes DESC.It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT Posts.OwnerUserId, TagName, COUNT(*) AS UpVotes FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Votes ON Votes.PostId = Posts.Id AND VoteTypeId = 2 WHERE TagName = '##TagName##' GROUP BY Posts.OwnerUserId, TagName ORDER BY UpVotes DESC