Most prolific answerers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select top ##Count##
  U.DisplayName
 ,count(P.Id) as Answers
 ,'https://codegolf.stackexchange.com/users/' + cast(U.Id as varchar) as Profile
from Users as U
 inner join Posts as P
  on P.OwnerUserId = U.Id
   and P.PostTypeId = 2  -- Answers only
   and P.CreationDate < '2020-01-01'
group by U.Id, U.DisplayName
order by Answers desc

Enter Parameters

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