ก่อนหน้านั้น สำหรับข้อมูลเพิ่มเติมเกี่ยวกับวัตถุประสงค์ของการสืบค้น โปรดดูhttps//www.webucator.com/blog/2016/03/still-using-python-2-it-is-time-to-upgrade/ ไม่จำเป็น ใช้ตารางทั้งหมด
s before that.

For more information on the purpose of the query, see https//www.webucator.com/blog/2016/03/still-using-python-2-it-is-time-to-upgrade/.It is not neccessary to use all the tables.
 ReviewTaskResults:  Id [ number]  ReviewTaskId [ number]  ReviewTaskResultTypeId [ number]  CreationDate [ time]  RejectionReasonId [ number]  Comment [ text] 
SELECT LEFT(t.TagName, 8) AS Tag, YEAR(p.CreationDate) AS y, COUNT(p.Id) AS NumPosts FROM Tags AS t JOIN PostTags AS pt ON pt.TagId = t.Id JOIN Posts AS p ON p.Id = pt.PostId WHERE (t.TagName LIKE 'python-2%' OR t.TagName LIKE 'python-3%') AND YEAR(p.CreationDate) >= 2012 GROUP BY LEFT(t.TagName, 8), YEAR(p.CreationDate) ORDER BY y, Tag DESC