Q&A about the site for programming puzzle enthusiasts and code golfers
SELECT TOP 100 q.OwnerUserId AS [AskerId], p.OwnerUserId AS [AnswererId], COUNT(*) AS [NumQuestionsAnswered] FROM Posts p INNER JOIN Posts q ON p.ParentId = q.Id WHERE p.PostTypeId = 2 AND q.PostTypeId = 1 AND q.OwnerUserId is NOT NULL AND p.OwnerUserId is NOT NULL GROUP BY q.OwnerUserId, p.OwnerUserId ORDER BY [NumQuestionsAnswered] DESC;