instruction: Multiple self answers from asker, sorted by the number of times self-answered. Multiple self answers from asker, sorted by the number of times self-answered, and filtered to exclude questions prior to Jan 1, 2010. (To avoid questions from 2008 with historical locks.)
response: SELECT question.Id AS "post_link", question.CreationDate, COUNT(selfAnswer.Id) AS "count" FROM Posts AS question INNER JOIN Posts AS selfAnswer ON selfAnswer.OwnerUserId = question.OwnerUserId AND selfAnswer.ParentId = question.Id INNER JOIN Users AS users ON Users.Id = question.OwnerUserId WHERE question.PostTypeId = 1 AND selfAnswer.PostTypeId = 2 GROUP BY question.Id, question.CreationDate HAVING COUNT(DISTINCT selfAnswer.Id) > 0 ORDER BY 'count' DESC, question.CreationDate DESC LIMIT 1000