SO - จำนวนโพสต์ทั้งหมดโดยเซิร์ฟเวอร์ฐานข้อมูลต่อเดือน - PostgreSQL ไม่จำเป็นต้องใช้ตารางทั้งหมด
SO - Total Posts by Database Server Per Month - PostgreSQL.It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT CONCAT(YEAR(P.CreationDate), '-', MONTH(P.CreationDate)) AS YearMonth, 'PostgreSQL' AS TagName, COUNT(*) AS PostCount FROM Posts AS P INNER JOIN PostTags AS PT ON (P.Id = PT.PostId) INNER JOIN Tags AS T ON (PT.TagId = T.Id) WHERE T.TagName LIKE 'postgresql%' GROUP BY YEAR(P.CreationDate), MONTH(P.CreationDate) ORDER BY YEAR(P.CreationDate) DESC, MONTH(P.CreationDate) DESC