Q&A about the site for linguists, teachers and students of the Ukrainian language
;with firstpostids_cte as ( SELECT MIN(Id) AS MinId, OwnerUserId FROM Posts WHERE PostTypeId=1 GROUP BY OwnerUserId ) , firstpostsclosed_cte as ( SELECT p.Id, p.CreationDate AS cre, p.ClosedDate AS clo FROM firstpostids_cte fp JOIN Posts p ON fp.MinId=p.Id ) SELECT year(cre), month(cre), ROUND((COUNT(clo))*100.0/(COUNT(*)),2) AS percentage FROM firstpostsclosed_cte GROUP BY year(cre), month(cre) ORDER BY year(cre), month(cre)