SELECT * จากโพสต์ LIMIT 10;.ไม่จำเป็นต้องใช้ตารางทั้งหมด
SELECT * FROM Posts LIMIT 10;.It is not neccessary to use all the tables.
 TagSynonyms:  Id [ number]  SourceTagName [ text]  TargetTagName [ text]  CreationDate [ time]  OwnerUserId [ number]  AutoRenameCount [ number]  LastAutoRename [ time]  Score [ number]  ApprovedByUserId [ number]  ApprovalDate [ time] 
SELECT u.Id, DisplayName, COUNT(p.Id) AS PostCount FROM Users AS u LEFT JOIN Posts AS p ON u.Id = p.OwnerUserId GROUP BY u.Id, DisplayName ORDER BY PostCount DESC LIMIT 10