Users With Most Questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select count(u.id), p.OwnerUserId, u.Reputation, u.DisplayName
from Posts p left join
     Users u
     on u.Id = p.OwnerUserId and u.reputation > 10000
where p.PostTypeId = 1
group by p.OwnerUserId, u.Reputation, u.DisplayName 
order by count(*) desc;

Enter Parameters

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