Users with most answers on closed questions

2

Please login or register to vote for this query.

(click on this box to dismiss)

Internet of Things Meta

Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors

SELECT TOP(##num?500##)
RANK() OVER(ORDER BY COUNT(a.Id) DESC) AS [Rank],
COUNT(a.Id) AS [Count],
a.OwnerUserId AS [User Link], a.OwnerDisplayName
FROM Posts q INNER JOIN Posts a ON a.ParentId=q.Id
WHERE (q.ClosedDate IS NOT NULL) 
GROUP BY a.OwnerUserId, a.OwnerDisplayName
ORDER BY COUNT(a.Id) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results