รวมโพสต์ประเภทต่างๆ ไม่จำเป็นต้องใช้ทุกตาราง
Totals of the various types of posts.It is not neccessary to use all the tables.
 PostHistory:  Id [ number]  PostHistoryTypeId [ number]  PostId [ number]  RevisionGUID [ other]  CreationDate [ time]  UserId [ number]  UserDisplayName [ text]  Comment [ text]  Text [ text]  ContentLicense [ text] 
SELECT MAX(pt.Name), COUNT(pt.Name) FROM PostTypes AS pt JOIN Posts AS p ON pt.Id = p.PostTypeId GROUP BY pt.Id