แท็กที่มีผู้ชมสูงสุดบนเว็บไซต์ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top Viewed Tags on a Site.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 t.TagName AS Tagname, AVG(t.Count) AS Count, SUM(p.ViewCount) AS Views FROM Tags AS t JOIN PostTags AS pt ON pt.TagId = t.Id JOIN Posts AS p ON p.Id = pt.PostId GROUP BY t.TagName ORDER BY SUM(p.ViewCount) DESC LIMIT 100