แท็กที่ปิดมากที่สุดใน StackOverflow (20 อันดับแรก) ไม่จำเป็นต้องใช้ตารางทั้งหมด
Most closed tags in StackOverflow (top 20).It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT Tags.TagName AS "Tag", COUNT(Posts.Id) AS "Questions" FROM Tags JOIN PostTags ON PostTags.TagId = Tags.Id JOIN Posts ON Posts.Id = PostTags.PostId WHERE NOT Posts.ClosedDate IS NULL GROUP BY Tags.TagName ORDER BY COUNT(Posts.Id) DESC LIMIT 20