A list of users who would qualify for the Minimum Standards badge. Community wiki and closed posts are not counted. For more information, see http://meta.stackoverflow.com/q/96050/162705
Q&A for linguists, teachers and students of the Korean language
-- Minimum Standards -- A list of users who would qualify for the Minimum Standards badge. Community wiki and closed posts are not counted. -- -- For more information, see http://meta.stackoverflow.com/q/96050/162705 SELECT Users.Id AS [User Link], Count(Posts.Id) AS Answers, CAST(AVG(CAST(Score AS float)) AS numeric(6,2)) AS [Average Answer Score] FROM Posts INNER JOIN Users ON Users.Id = OwnerUserId WHERE PostTypeId = 2 AND CommunityOwnedDate is null AND ClosedDate is null GROUP BY Users.Id, DisplayName HAVING Count(Posts.Id) >= 10 AND CAST(AVG(CAST(Score AS float)) AS numeric(6,2)) >= 2 ORDER BY [Average Answer Score] DESC