น้ำหนักรวมของการมีส่วนร่วมจากผู้ใช้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Total weight of contributions from a user.It is not neccessary to use all the tables.
 PostNotices:  Id [ number]  PostId [ number]  PostNoticeTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ExpiryDate [ time]  Body [ text]  OwnerUserId [ number]  DeletionUserId [ number] 
SELECT PostTypeId, SUM(LENGTH(Body)) AS weight FROM Posts WHERE OwnerUserId = '##UserId##' GROUP BY PostTypeId UNION SELECT PostTypeId + 100 AS posttypeid, SUM(LENGTH(Body)) AS weight FROM Posts WHERE OwnerUserId = '##UserId##' AND Score > 0 GROUP BY PostTypeId UNION SELECT 0 AS posttypeid, SUM(LENGTH(Text)) AS weight FROM Comments WHERE UserId = '##UserId##' UNION SELECT 100 AS posttypeid, SUM(LENGTH(Text)) AS weight FROM Comments WHERE UserId = '##UserId##' AND Score > 0 ORDER BY PostTypeId