Top 100 question askers


Please login or register to vote for this query.

(click on this box to dismiss)

Sustainable Living

Q&A for folks dedicated to a lifestyle that can be maintained indefinitely without depleting available resources

select top 100 sel.Id as [User Link], sel.n as [#Questions]
(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

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