ผู้ใช้ที่มีชื่อเสียง < 5,000 คนที่โพสต์คำตอบมากที่สุด ไม่จำเป็นต้องใช้ทุกตาราง
Users with reputation < 5,000 who posted the most answers.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.Id AS "user_link", Users.DisplayName, Users.Reputation, SUM(CASE WHEN Posts.PostTypeId = 1 THEN 1 ELSE 0 END) AS Questions, SUM(CASE WHEN Posts.PostTypeId = 2 THEN 1 ELSE 0 END) AS Answers, Users.UpVotes, Users.DownVotes FROM Users INNER JOIN Posts ON Users.Id = Posts.OwnerUserId AND (Posts.PostTypeId = 1 OR Posts.PostTypeId = 2) AND Users.Reputation > 1 AND Users.Reputation < 5000 GROUP BY Users.Id, Users.CreationDate, Users.LastAccessDate, Users.Reputation, Users.DisplayName, Users.CreationDate, Users.Views, Users.UpVotes, Users.DownVotes ORDER BY Answers DESC LIMIT 100