Q&A for users and developers of the Cardano cryptocurrency ecosystem
DECLARE @MinAnswers int = ##MinAnswers## SELECT TOP 20 p.OwnerUserId, u.DisplayName, u.Reputation, AVG(p.Score) AS AverageScore, COUNT(*) AS AnswerCount FROM Posts p INNER JOIN Users u ON p.OwnerUserId = u.Id WHERE p.PostTypeId = 2 AND p.DeletionDate IS NULL AND p.OwnerUserId IS NOT NULL GROUP BY p.OwnerUserId, u.DisplayName, u.Reputation HAVING count(*) >= @MinAnswers ORDER BY AVG(p.Score) DESC;