0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for participants in team and individual sport activities

select Us.DisplayName, Questions.Quantity from Users us join ( 
select top 10 U.Id, count(p.id) as Quantity 
from Users U join Posts P on U.Id = P.OwnerUserId 
where P.PostTypeId = 1 
group by U.Id 
order by max(U.Reputation) desc 
 ) Questions on us.Id = Questions.Id 
 order by us.Reputation desc;

fork query

edited dec 12 17

created dec 11 17 anonymous