Top 100 question askers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

select top 100 sel.Id as [User Link], sel.n as [#Questions]
from
(select u.Id, count(*) as [n]
from Users u inner join Posts p on p.OwnerUserId = u.Id
where p.PostTypeId = 1 -- questions
 and p.ClosedDate is null -- not closed
 and p.Score > 0
 group by u.Id) sel
order by sel.n desc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results