Top 100 question askers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Apps

Q&A for apps, scripts, and development with the Stack Exchange API

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 sites:
loading Hold tight while we fetch your results