Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
Select Datediff(year, p.CreationDate, Current_Timestamp) as Age, convert(DECIMAL(10,2), sum(case when p.AcceptedAnswerId is null then 1 else 0 end) ) / count(p.Id) as PercentAccepted From Posts p Where p.PostTypeId = 1 Group by Datediff(year, p.CreationDate, Current_Timestamp) Order by Datediff(year, p.CreationDate, Current_Timestamp) desc