instruction: Closed question percentage by month.
response: SELECT (SELECT COUNT(ClosedDate) FROM Posts WHERE PostTypeId = 1) AS "Closed", COUNT(*) AS "Total", CONCAT(YEAR(q.CreationDate), '/', MONTH(q.CreationDate)) AS "Month" FROM Posts AS q WHERE PostTypeId = 1 GROUP BY CONCAT(YEAR(q.CreationDate), '/', MONTH(q.CreationDate))