Q&A for active researchers, academics and students of physics
-- Minimum number of answers a user must have written to be included. DECLARE @MinAnswers int = ##MinAnswers## SELECT TOP 100 Users.Id AS [User Link], SUM(Posts.Score) AS "Upvotes earned", COUNT(*) AS "Answers written", 1.0 * SUM(Posts.Score) / COUNT(*) AS "Average answer score" FROM Posts LEFT JOIN Users ON Posts.OwnerUserId = Users.Id WHERE Posts.PostTypeId = 2 GROUP BY Users.Id HAVING COUNT(*) >= @MinAnswers ORDER BY "Average answer score" DESC