1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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

fork query

edited may 17

created may 17 Randriakotonjanahary.Tolotra.Samuel