instruction: Number of questions which get closed (per day, between dates).
response: SELECT DATE(p.CreationDate), COUNT(p.ClosedDate) AS closed, COUNT(*) AS total, 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)