ผู้ใช้บริการจะปิดภายใน 24 ชั่วโมงนับจากโพสต์แรก ไม่จำเป็นต้องใช้ตารางทั้งหมด
users with closure within 24 hours of first post.It is not neccessary to use all the tables.
 Votes:  Id [ number]  PostId [ number]  VoteTypeId [ number]  UserId [ number]  CreationDate [ time]  BountyAmount [ number] 
SELECT udfp.OwnerUserId, COUNT(ph.Id) AS numclosures FROM (SELECT p.OwnerUserId, MIN(p.CreationDate) AS dfp FROM Posts AS p WHERE p.PostTypeId < 3 GROUP BY p.OwnerUserId) AS udfp LEFT OUTER JOIN Posts AS p ON p.OwnerUserId = udfp.OwnerUserId AND p.PostTypeId = 1 LEFT OUTER JOIN PostHistory AS ph ON ph.PostHistoryTypeId = 10 AND ph.PostId = p.Id AND CAST((JULIANDAY(CreationDate) - JULIANDAY(udfp.dfp)) AS INT) < 24 GROUP BY udfp.OwnerUserId HAVING COUNT(ph.Id) > 0 ORDER BY COUNT(ph.Id) DESC