Q&A about the site for active researchers, academics and students of physics
SELECT TOP(##num?100##) a.OwnerUserId as [User Link], a.OwnerDisplayName, COUNT(a.Id) AS [Count], SUM(a.Score) AS [Score] FROM Posts q INNER JOIN Posts a ON q.Id=a.ParentId WHERE (q.OwnerUserid=##userid##) GROUP by a.OwnerUserId, a.OwnerDisplayName ORDER BY COUNT (a.Id) DESC