Q&A about the site for developers and users of the secure, private and untraceable cryptocurrency Monero
;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 CAST(cre AS date), ROUND((COUNT(clo))*100.0/(COUNT(*)),2) AS percentage FROM firstpostsclosed_cte GROUP BY CAST(cre AS date) ORDER BY CAST(cre AS date)