Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
select Total, TotalFechadas, TotalFechadas * 100 / Total as PorcentagemFechadas FROM (SELECT count(Id) Total, SUM(CASE WHEN ClosedDate IS NOT NULL THEN 1 ELSE 0 END) TotalFechadas FROM Posts WHERE CreationDate BETWEEN '2019-01-01' AND '2019-05-22') t;