จำนวนคำถามพร้อมแท็กที่สร้างขึ้นในปีที่แล้ว ไม่จำเป็นต้องใช้ตารางทั้งหมด
Number of Questions With Tag created in the last year.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 TagName, COUNT(TagName) FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE Tags.TagName IN ('clojure', 'elm', 'python', 'racket') AND Posts.PostTypeId = 1 GROUP BY TagName