Q&A for information security professionals
SELECT COUNT(*) as cnt from Posts where PostTypeId=1 GROUP BY ClosedDate