0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software quality control experts, automation engineers, and software testers

-- Enter Query Title

SELECT TOP 100
Id [User Link], Reputation, count Answers, Reputation / count ratio
FROM Users u
INNER JOIN (SELECT OwnerUserId, COUNT(*) count
            FROM Posts
            GROUP BY OwnerUserId) a
ON u.Id = a.OwnerUserId
WHERE Reputation > ##MinRep##
ORDER BY ratio DESC;
-- Enter Query Description

fork query

edited dec 7 13

created dec 7 13 anonymous