instruction: Question answered after >30 days.
response: SELECT COUNT(*) FROM Posts AS questions LEFT JOIN Posts AS answers ON questions.AcceptedAnswerId = answers.Id WHERE questions.PostTypeId = 1 AND DATEDIFF(day, questions.CreationDate, creationdate) > 30