A list of users who would qualify for the Quality Assurance 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
-- Quality Assurance -- A list of users who would qualify for the Quality Assurance 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) >= 20 AND CAST(AVG(CAST(Score AS float)) AS numeric(6,2)) > 3 ORDER BY [Average Answer Score] DESC