ชื่อเสียงเฉลี่ยต่อวันเพิ่มขึ้นจากโพสต์เก่าๆ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Average reputation gain per day from old posts.It is not neccessary to use all the tables.
 ReviewRejectionReasons:  Id [ number]  Name [ text]  Description [ text]  PostTypeId [ number] 
SELECT temp.Average, u.Id AS "user_link", u.Reputation FROM (SELECT SUM(CASE p.PostTypeId WHEN 1 THEN 5 WHEN 2 THEN 10 ELSE 0 END) / 31.0 AS "Average", p.OwnerUserId FROM Votes AS v INNER JOIN Posts AS p ON v.PostId = p.Id WHERE v.VoteTypeId = 2 AND p.CreationDate < '2018-01-01' AND v.CreationDate BETWEEN '2018-07-01' AND '2018-07-31' AND p.CommunityOwnedDate IS NULL AND NOT p.OwnerUserId IS NULL GROUP BY p.OwnerUserId ORDER BY SUM(CASE p.PostTypeId WHEN 1 THEN 5 WHEN 2 THEN 10 ELSE 0 END) DESC LIMIT 100) AS temp INNER JOIN Users AS u ON temp.OwnerUserId = u.Id