Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language
select count(p.Id) from Posts as p join Posts as q on p.Id = (select top 1 Id from posts where parentId = q.Id and CreationDate < DATEADD(month, -3, GETDATE()) -- at least 3 months old and LastEditDate < DATEADD(month, -3, GETDATE()) -- at least 3 months untouched and LEN(Body) > 450 -- more than 450 chars used (TODO: striptags) and Score >= 2 -- Score >= 3 ORDER BY NEWID()) -- only answers and q.ClosedDate IS NULL and p.CommunityOwnedDate IS NULL -- not closed, not community wiki and q.AnswerCount <= 10 -- not more than 30 answers (pagination)