Q&A for professionals, academics, and students working within the systems development life cycle
SELECT TOP 10 OwnerUserId [User Link], AVG(Score) FROM Posts p GROUP BY OwnerUserId HAVING COUNT(*) > 100 AND AVG(Score) > (SELECT AVG(Score) FROM Posts WHERE OwnerUserId = 22656) AND (SELECT Reputation FROM Users u WHERE OwnerUserId = u.Id) > 100 ORDER BY AVG(Score) DESC