ซึ่งปิดทำการ (ต่อวัน ระหว่างวันที่) ไม่จำเป็นต้องใช้ทุกตาราง
s which get closed (per day, between dates).It is not neccessary to use all the tables.
 Badges:  Id [ number]  UserId [ number]  Name [ text]  Date [ time]  Class [ number]  TagBased [ boolean] 
SELECT DATE(p.CreationDate), ROUND((COUNT(p.ClosedDate)) * 100.0 / (COUNT(p.Id)), 2) AS percentage FROM Posts AS p WHERE p.CreationDate >= '##Date1##' AND p.CreationDate <= '##Date2##' AND p.PostTypeId = 1 GROUP BY DATE(p.CreationDate) ORDER BY DATE(p.CreationDate)