ผู้ได้รับคะแนนโหวต 'R' อันดับต้นๆ พร้อมเว็บไซต์ ไม่จำเป็นที่จะต้องใช้ตารางทั้งหมด
Top 'R' Vote Getters with A Website.It is not neccessary to use all the tables.
 PostNotices:  Id [ number]  PostId [ number]  PostNoticeTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ExpiryDate [ time]  Body [ text]  OwnerUserId [ number]  DeletionUserId [ number] 
SELECT Users.DisplayName, Users.Id, sub.totalVotes, Users.WebsiteUrl FROM (SELECT Users.Id, COUNT(*) AS totalVotes 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 Votes.VoteTypeId = 2 INNER JOIN Users ON Posts.OwnerUserId = Users.Id WHERE Tags.TagName = 'r' AND Posts.PostTypeId IN (1, 2) GROUP BY Users.Id) AS sub INNER JOIN Users ON Users.Id = sub.Id WHERE Users.WebsiteUrl != '' ORDER BY sub.totalVotes DESC LIMIT 25