Users with the most answers per day

5

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select top 500
     u.Id as [User Link]
     , datediff(dd, u.creationdate, GETDATE() ) as [Days]
     , count(a.Id) as [Total Answers]  
     , cast(count(a.Id) as float)*sign(count(a.Id) - 99) / datediff(dd, u.creationdate, GETDATE()) as [Answers/Day Ratio]
     , avg(a.score * 1.0) as [AvgScorePerAnswer]
from Users u
inner join Posts a 
on a.OwnerUserId = u.Id
where a.PostTypeId=2
group by u.Id, u.creationdate
order by [Answers/Day Ratio] desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results