0

Please login or register to vote for this query.

(click on this box to dismiss)

ordered by close rate of the user's posts adapted from "per tag close rate": http://data.stackexchange.com/stackoverflow/s/1266/

Q&A for anime and manga fans

-- Users with N or more closed posts
-- ordered by close rate of the user's posts
-- adapted from "per tag close rate": http://data.stackexchange.com/stackoverflow/s/1266/

SELECT TOP 100
    u.id as [User Link],
    COUNT(*) [Total Posts],
    COUNT(ClosedDate) [Closed Posts],
    100.0 * COUNT(ClosedDate) / count(*) as [Close Rate]
FROM users as u
JOIN Posts as p ON p.owneruserId = u.Id
GROUP BY u.id
HAVING COUNT(ClosedDate) >= ##MinimumClosedPostCount:int##
ORDER BY 100.0 * COUNT(ClosedDate) / COUNT(*) desc

fork query

created nov 1 11 burpenator