Python vs R บน CrossValidated ไม่จำเป็นต้องใช้ตารางทั้งหมด
Python vs R on CrossValidated.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 *, COUNT(*) AS count FROM (SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS "month", t.TagName AS "tag" FROM Posts AS p JOIN PostTags AS pt ON pt.PostId = p.Id JOIN Tags AS t ON t.Id = pt.TagId WHERE t.TagName IN ('python', 'r', 'sas', 'stata', 'spss')) AS X GROUP BY 'tag', month ORDER BY 'tag', month