Arqade [คำสั่ง minecraft] คะแนนเฉลี่ยต่อชื่อเสียงของผู้ใช้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Arqade [minecraft-commands] average score per user reputation.It is not neccessary to use all the tables.
 PostNoticeTypes:  Id [ number]  ClassId [ number]  Name [ text]  Body [ text]  IsHidden [ boolean]  Predefined [ boolean]  PostNoticeDurationId [ number] 
SELECT AVG(CAST(pp.Score AS FLOAT)) AS Average_Score, SUM(pp.Score) AS Score_Sum, COUNT(pp.REP_BUCKET) AS Post_Count, pp.REP_BUCKET AS Reputation_Bucket FROM (SELECT p.Score, CASE WHEN u.Reputation <= 50 THEN ' 000 - 50' WHEN u.Reputation > 50 AND u.Reputation <= 100 THEN '051 - 100' WHEN u.Reputation > 100 AND u.Reputation <= 200 THEN '101 - 200' WHEN u.Reputation > 200 AND u.Reputation <= 300 THEN '201 - 300' WHEN u.Reputation > 300 AND u.Reputation <= 400 THEN '301 - 400' ELSE 'over 400' END AS REP_BUCKET FROM Posts AS p JOIN Users AS u ON p.OwnerUserId = u.Id WHERE p.PostTypeId = 1 AND p.Tags LIKE '%minecraft-commands%' ORDER BY p.CreationDate DESC LIMIT 1000) AS pp GROUP BY pp.REP_BUCKET ORDER BY pp.REP_BUCKET DESC