Does not count self-answers. Shows users with at least @MinAnswers answers.
Q&A for active researchers, academics and students of physics
-- Users who score lower than the questions they answer -- Does not count self-answers. -- Shows users with at least @MinAnswers answers. DECLARE @MinAnswers int = ##MinAnswers## SELECT TOP 100 u.Id AS [User Link], count(*) AS NumAnswers, avg(q.Score - a.Score) AS AvgVoteDelta FROM Posts a INNER JOIN Users u ON u.Id = a.OwnerUserId INNER JOIN Posts q ON a.ParentId = q.Id WHERE (q.OwnerUserId <> u.Id OR q.OwnerUserId IS NULL) and --no self answers q.Tags like '%<##TagName##>%' GROUP BY u.Id HAVING count(*) >= @MinAnswers ORDER BY AvgVoteDelta DESC, NumAnswers DESC