จำนวนโพสต์ที่สร้างใน symfony2, laravel และ zend-framework2 ตั้งแต่ปี 2012 ไม่จำเป็นต้องใช้ตารางทั้งหมด
Number of posts created in symfony2, laravel and zend-framework2 since 2012.It is not neccessary to use all the tables.
 SuggestedEditVotes:  Id [ number]  SuggestedEditId [ number]  UserId [ number]  VoteTypeId [ number]  CreationDate [ time]  TargetUserId [ number]  TargetRepChange [ number] 
SELECT TagName, YEAR(Posts.CreationDate) AS year, COUNT(*) AS postcount FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.Id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId WHERE (TagName = 'symfony2' OR TagName = 'laravel' OR TagName = 'zend-framework2') GROUP BY TagName, YEAR(Posts.CreationDate) HAVING YEAR(Posts.CreationDate) >= 2012 ORDER BY year DESC, postcount DESC