ผู้ตอบ Python 100 อันดับแรกในช่วง 100 วันที่ผ่านมาในชิคาโก ไม่จำเป็นต้องใช้ตารางทั้งหมด
Top 100 Python Answerers in the last 100 days in Chicago.It is not neccessary to use all the tables.
 VoteTypes:  Id [ number]  Name [ text] 
SELECT u.Id AS "user_link", number_of_answers = COUNT(*), total_score = SUM(p.Score) FROM Users AS u JOIN Posts AS p ON p.OwnerUserId = u.Id JOIN Posts AS pp ON p.ParentId = pp.Id JOIN PostTags AS pt ON pt.PostId = pp.Id JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName LIKE '%clojure%' AND p.CreationDate > (CURRENT_TIMESTAMP() - 100) AND u.Location LIKE '%UK%' GROUP BY u.Id ORDER BY 2 DESC LIMIT 100