เปอร์เซ็นต์ของโพสต์ที่มีคะแนน >1, 0 และ <1 ตามประเภทโพสต์ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Percentage of Posts w/ Scores of >1, 0 and <1, by Post Type.It is not neccessary to use all the tables.
 Posts:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT pt.Name AS "Type", COUNT(p.Id) AS "Total", CAST(ROUND(COUNT(CASE WHEN p.Score > 0 THEN 1 ELSE NULL END) / CAST(COUNT(p.Id) AS FLOAT) * 100, 4) AS TEXT(7)) + '%' AS "+", CAST(ROUND(COUNT(CASE WHEN p.Score = 0 THEN 1 ELSE NULL END) / CAST(COUNT(p.Id) AS FLOAT) * 100, 4) AS TEXT(7)) + '%' AS "0", CAST(ROUND(COUNT(CASE WHEN p.Score < 0 THEN 1 ELSE NULL END) / CAST(COUNT(p.Id) AS FLOAT) * 100, 4) AS TEXT(7)) + '%' AS "-" FROM Posts AS p JOIN PostTypes AS pt ON p.PostTypeId = pt.Id GROUP BY pt.Name ORDER BY COUNT(p.Id) DESC